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