Data that a client application converts

When the code sets of two locales differ, the HCL OneDB™ client product must use code-set conversion to prevent data corruption of character data.

Code-set conversion converts the following character data elements:
  • Values of SQL data types:
    • CHAR, VARCHAR, NCHAR, and NVARCHAR
    • TEXT (the BYTE data type is not converted)
    • LVARCHAR
    • Character data in opaque data types (if their support functions perform the code-set conversions)
  • Values of character types (char, fixchar, string, and varchar)
  • SQL statements, both static and dynamic
  • SQL identifiers. These include names of columns, tables, views, prepared statements, cursors, constraints, indexes, triggers, and other database objects. For a list of SQL objects that can include non-ASCII characters in their identifiers, see Non-ASCII characters in identifiers.
  • SPL text
  • Command text
  • Error message text in the sqlca.sqlerrm field