INPUT:

-- MSSQL 2000
-- ###########################################################
DROP TABLE chartest;  -- may give error (OK)
CREATE TABLE chartest (
  charval1 CHAR(10),
  charval2 CHAR(10),
  varcharval VARCHAR(30)
);
INSERT INTO chartest VALUES ('aaa','aaa','aaa');
-- commit here, if needed
INSERT INTO chartest
  VALUES ('aaaaaaaaaaaa','aaa','aaa'); -- should give error
SELECT * FROM chartest;
SELECT * FROM chartest WHERE charval1=varcharval;
SELECT charval1 + 'X' AS res FROM chartest;
SELECT LEN(charval1 + charval2) AS res FROM chartest;
SELECT LEN(charval1) + LEN(charval2)
  AS res
  FROM chartest;




OUTPUT:


troels@microsoft:windows> -- MSSQL 2000
troels@microsoft:windows> -- ###########################################################
troels@microsoft:windows> DROP TABLE chartest;  -- may give error (OK)
affected 0 rows (2 msec)
troels@microsoft:windows> CREATE TABLE chartest (
                            charval1 CHAR(10),
                            charval2 CHAR(10),
                            varcharval VARCHAR(30)
                          );
affected 0 rows (2 msec)
troels@microsoft:windows> INSERT INTO chartest VALUES ('aaa','aaa','aaa');
affected 1 rows (4 msec)
troels@microsoft:windows> -- commit here, if needed
troels@microsoft:windows> INSERT INTO chartest
                            VALUES ('aaaaaaaaaaaa','aaa','aaa'); -- should give error
FAILURE: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]String or binary data would be truncated.
troels@microsoft:windows> SELECT * FROM chartest;
------------+------------+------------+
  charval1  |  charval2  | varcharval |
------------+------------+------------+
 aaa        | aaa        | aaa        |
------------+------------+------------+
1 row in result (first row: 3 msec; total: 4 msec)
troels@microsoft:windows> SELECT * FROM chartest WHERE charval1=varcharval;
------------+------------+------------+
  charval1  |  charval2  | varcharval |
------------+------------+------------+
 aaa        | aaa        | aaa        |
------------+------------+------------+
1 row in result (first row: 3 msec; total: 4 msec)
troels@microsoft:windows> SELECT charval1 + 'X' AS res FROM chartest;
-------------+
     res     |
-------------+
 aaa       X |
-------------+
1 row in result (first row: 2 msec; total: 3 msec)
troels@microsoft:windows> SELECT LEN(charval1 + charval2) AS res FROM chartest;
-----+
 res |
-----+
  13 |
-----+
1 row in result (first row: 3 msec; total: 3 msec)
troels@microsoft:windows> SELECT LEN(charval1) + LEN(charval2)
                            AS res
                            FROM chartest;
-----+
 res |
-----+
   6 |
-----+
1 row in result (first row: 3 msec; total: 4 msec)