INPUT:

-- MimerSQL 9.1.3A
-- ##########################################################
DROP TABLE chartest; -- may give error (OK)
CREATE TABLE chartest (
  charval1 CHAR(10) NOT NULL,
  charval2 CHAR(10) NOT NULL,
  varcharval VARCHAR(30) NOT NULL
);
INSERT INTO chartest VALUES ('aaa','aaa','aaa');
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 CHAR_LENGTH(charval1 || charval2) AS res FROM chartest;
SELECT character_length(charval1) + character_length(charval2)
  AS res
  FROM chartest;


OUTPUT:

SQL>-- MimerSQL 9.1.3A
SQL>-- ##########################################################
SQL>DROP TABLE chartest; -- may give error (OK)
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 ('aaaaaaaaaaaa','aaa','aaa'); -- should give error
MIMER/DB error -10311 in function EXECUTE
         String data truncated
SQL>SELECT * FROM chartest;
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 character_length(charval1) + character_length(charval2)
SQL&  AS res
SQL&  FROM chartest;
         RES
============
          20
 
                  1 row found