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 HCL OneDB™ Guide to SQL: Reference describes these types. For information about collation, see ids_gug_025.html#ids_gug_025.