Db_Locale database parameter
Description
Db_Locale identifies the locale of the
data in the database.
When to specify Db_Locale
You must specify the Client_Locale parameter before connecting
to a database.
Controls
-
I10 Informix
Syntax
|
1 |
Db_Locale='<span>language</span>_<span>territory</span>.<span>codeset</span>' |
|
Parameter |
Description |
|---|---|
|
language |
Two character name that represents the |
|
territory |
Two character name that represents the |
|
codeset |
Name of the code set that the locale |
Default
Client_Locale value.
Usage
The I10 native interface uses the Informix GLS (Global Language
Support) API for global language support. Db_Locale
specifies the value of the Informix environment variable DB_LOCALE.
If you do not set the DbParameter, the default Db_Locale
value is the Client_Locale value.
Db_Locale specifies the language, territory, and
code set that the database server needs to correctly interpret locale-sensitive
datatypes such as NChar and NVarChar in
a specific database. The code set specified in DB_LOCALE determines
which characters are valid in any character column, as well as in
the names of database objects such as databases, tables, columns,
and views.
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
.
Examples
To set the database locale to ‘en_us.utf8’:
-
Database profile
Type the following in the Database Locale box on the Regional
Settings page in the Database Profile Setup dialog box:1en_us.utf8 -
Application
Type the following in code:
1SQLCA.DbParameter="Db_Locale='en_us.utf8'"