Client_Locale identifies the locale that the client application uses.
When to specify Client_Locale
You must specify the Client_Locale parameter before connecting
to a database.
I10 Informix
Client_locale='language_territory.codeset'
Parameter |
Description |
|---|---|
language |
Two character name that represents the language for a specific locale, for example “en” for English. |
territory |
Two character name that represents the cultural conventions for a specific territory, for example “AU” for Australia. |
codeset |
Name of the code set that the locale supports, for example “utf8.” |
Based on the operating system’s locale.
The I10 native interface uses the Informix GLS (Global Language Support) API for global language support. Client_Locale specifies the value of the Informix environment variable CLIENT_LOCALE. The I10 interface uses this setting to access string data in an Informix database and to process SQL statements. If you do not set the DBParm, the default client locale value is based on the OS locale.
For example, to access a database that has a Japanese SJIS
locale, Client_Locale should be set to ja_jp.sjis on
the client system.
For more information about the Informix CLIENT_LOCALE and DB_LOCALE environment variables, see the IBM Informix GLS User's Guide, currently available at the Informix library Web site.
To set the client locale to 'en_us.utf8':
Database profile Type the following in the Client Locale box on the Regional Settings page in the Database Profile Setup dialog box:
en_us.utf8
Application Type the following in code:
SQLCA.DBParm="Client_Locale='en_us.utf8'"
