Client_Locale
database parameter
Description
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.
Applies to
I10 Informix
Syntax
|
1 |
Client_locale='language_territory.codeset' |
|
Parameter |
Description |
|---|---|
|
language |
Two character name that represents the language for |
|
territory |
Two character name that represents the cultural |
|
codeset |
Name of the code set that the locale supports, for |
Default value
Based on the operating system’s locale.
Usage
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 https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.glsug.doc/glsug.htm.
Examples
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:1en_us.utf8 -
Application
Type the following in code:
1SQLCA.DBParm="Client_Locale='en_us.utf8'"
See also