Support for non-ASCII characters

HCL OneDB™ products obtain the code set from its GLS locale. Locales are available for both single-byte and multibyte code sets.

All supported code sets define the ASCII characters. Most also support additional non-ASCII characters (8-bit or multibyte characters). For more information about code sets and non-ASCII characters, see Code sets for character data.

The following types of GLS locales are examples of locales that contain non-ASCII characters in their code sets:
  • The default locale supports the default code set, which contains 8-bit characters for non-English characters such as é, ñ, and ö.

    The name of the default code set depends on the platform on which your HCL OneDB product is installed. For more information about the default code set, The default code set.

  • Many nondefault locales support the default code set.

    Nondefault locales that support the UNIX™ default code set, ISO8859-1, include British English (en_gb.8859-1), French (fr_fr.8859-1), Spanish (es_es.8859-1), and German (de_de.8859-1).

  • Other nondefault locales, such as Japanese SJIS (ja_jp.sjis), Korean (ko_kr.ksc), and Chinese (zh_cn.gb), contain multibyte code sets. (The unified Chinese code set is GB18030-2000.)
  • A nondefault locale, zh_cn.utf8, contains a multibyte code set. (The unified Chinese code set is GB18030-2000.)

For the contexts in which you can use non-ASCII characters, including multibyte characters, see SQL features, Database server features, and General SQL API features (ESQL/C).

For the HCL OneDB product to support non-ASCII characters, however, it must use a locale that supports a code set with the same non-ASCII characters.