Multibyte characters with CLOB

About this task

You can insert data into CLOB columns in the following ways:
  • With the dbload or onload utilities
  • With the LOAD statement (DB-Access)
  • From CLOB (ifx_lo_t) host variables (ESQL/C)

For examples of CLOB types, see the HCL OneDB™ Guide to SQL: Tutorial and the HCL OneDB Database Design and Implementation Guide.

With GLS, the following rules apply:
  • Multibyte CLOB characters must be defined in the database locale.
  • The CLOB data type is collated in code-set order.
  • The database server handles code-set conversions for CLOB data.

For more information about database locales, collation order, and code-set conversion, see the HCL OneDB GLS User's Guide.