Compatibility between data types

If values are used in calculations, predicates and assignments, the data types of the operands involved must be compatible.

Two data types are compatible if they fulfill the following conditions:

• Both data types are CHAR or VARCHAR.

• Both data types are NCHAR or NVARCHAR.

• Both data types are numeric (SMALLINT, INTEGER, NUMERIC, DECIMAL, REAL, DOUBLE PRECISION or FLOAT).

• Both data types are DATE.

• Both data types are TIME.

• Both data types are TIMESTAMP.

Values from various character sets are not converted implicitly in SESAM/SQL to make them compatible.
Transliteration of strings is possible with the TRANSLATE function, see the section “TRANSLATE() - Transliterate / transcode string”.