Character data types

The locale affects the collation of built-in SQL character data types.

The SQL character data types are:

Character types that use localized collation: NCHAR and NVARCHAR
Character types that use code-set order for collation:
- CHAR
- LVARCHAR
- VARCHAR
- TEXT

The IBM Informix Guide to SQL: Reference describes these types. For information about collation, see Character classes of the code set.