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.


Copyright© 2020 HCL Technologies Limited