SQL>CREATE TABLE chartest (
SQL&  charval1 CHAR(10) NOT NULL,
SQL&  charval2 CHAR(10) NOT NULL,
SQL&  varcharval VARCHAR(30) NOT NULL
SQL&);
SQL>INSERT INTO chartest VALUES ('aaa','aaa','aaa');
SQL>INSERT INTO chartest
SQL&  VALUES ('aaaaaa      ','aaa','aaa'); -- should truncate to 'aaaaaa    '
SQL>INSERT INTO chartest
SQL&  VALUES ('aaaaaaaaaaaa','aaa','aaa'); -- should throw error
MIMER/DB error -10311 in function EXECUTE
         String data truncated
SQL>SELECT * FROM chartest; -- should show two rows
CHARVAL1   CHARVAL2   VARCHARVAL
========== ========== ==============================
aaa        aaa        aaa
aaaaaa     aaa        aaa
 
                  2 rows found
 
SQL>DELETE FROM chartest WHERE charval1='aaaaaa';
 
                  1 row deleted
 
SQL>SELECT * FROM chartest; -- shoud show one row
CHARVAL1   CHARVAL2   VARCHARVAL
========== ========== ==============================
aaa        aaa        aaa
 
                  1 row found
 
SQL>SELECT * FROM chartest WHERE charval1=varcharval;
CHARVAL1   CHARVAL2   VARCHARVAL
========== ========== ==============================
aaa        aaa        aaa
 
                  1 row found
 
SQL>SELECT charval1 || 'X' AS res FROM chartest;
RES
===========
aaa       X
 
                  1 row found
 
SQL>SELECT CHAR_LENGTH(charval1 || charval2) AS res FROM chartest;
        RES
===========
         20
 
                  1 row found
 
SQL>SELECT CHAR_LENGTH(charval1) + CHAR_LENGTH(charval2)
SQL&  AS res
SQL&  FROM chartest;
         RES
============
          20
 
                  1 row found