DB_LOCALE and CLIENT_LOCALE are compatible if ...
- the code set for both the locales are identical,
- code set conversion is possible between CLIENT_LOCALE's and DB_LOCALE's code set,
OR
AND
a locale consisting of the language_terriorty from CLIENT_LOCALE and the code set from DB_LOCALE exist
- Note: For any code set name, its corresponding code set number and hex value, can be found in following file.
- $INFOMRIXDIR/gls/cm3/registry.
Example 1:
- DB_LOCALE = en_us.850 (code set 850, its hex value 0352)
CLIENT_LOCALE = de_de.850
Here, both the locales are using same code set, 850 which is supported by both en_us and de_de, that is, US English and Germany German.
Hence, they are compatible.
Example 2:
- CLIENT_LOCALE = fr_ca.850 (code set 850, its hex value 0352)
DB_LOCALE = de_de.cp1252 (code set 1252, its hex value 04e4)
- Here, for both the locales to be compatible, there are 2 requirements:
- i) Canadian French (fr_ca) must support code set 1252 encoding.
- In other words, this locale file must exit.
- $INFORMIXDIR/gls/lc11/fr_ca/04e4.lco
ii) Conversion between CLIENT_LOCALE's code set, 850 and
- DB_LOCALE's code set, cp1252 must be supported.
- In other words, these files must exist.
- $INFORMIXDIR/gls/cv9/035204e4.cvo
$INFORMIXDIR/gls/cv9/04e40352.cvo
- If you have locales fr_ca and de_de, for code set 850 and cp1252, installed on the machine, you
should see the above listed files exists.
Hence, they are compatible locale.
Example 3:
- CLIENT_LOCALE = fr_ca.850 (code set 850, its hex value 0352)
DB_LOCALE = cs_cz.8859-2 (code set 8859-2, its hex value 0390)
- Here, the locales are not compatible because ...
- Canadian French (fr_ca) does not support 8859-2 encoding, and
- conversion between code set 850 and 8859-2 is not supported.
Example 4:
- CLIENT_LOCALE = iw_il.8859-8 (code set 8859-8, its hex value 0394)
DB_LOCALE = en_us.utf8 (code set utf8, its hex value e01c)
- Here, even though code conversion is posible between code set 8859-8 and utf8, these locales
are not compatible because Israelian hebrew (iw_il) does not support utf8 encoding.
That is, there is no such locale file to support utf8 encoding by Israelian hebrew.
- $INFORMIXDIR/gls/lc11/iw_il/e01c.lco
Note: If a locale file is not available in your INFORMIXDIR, check the Informix International
Language Suppliment (ILS) to see if that the locale is supported.
Seema Kumari
[Read More]