Support for non-ASCII characters

HCL Informix® 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 Informix® 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.)

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 Informix® product to support non-ASCII characters, however, it must use a locale that supports a code set with the same non-ASCII characters.