Client locale |
- Description:
- Locale and code set that the application runs in
- Format:
- locale.codeset@modifier
- odbc.ini field for UNIX:
- CLIENT_LOCALE
- Default value for UNIX:
- en_us.8859-1
- Default value for Windows:
- en_us.1252
Important: The setting of the CLIENT_LOCALE environment
variable in the operating system environment and in Setnet32 are ignored
by IBM Informix ODBC Driver.
To change the client locale, you must use this GLS option.
|
Database locale |
- Description:
- Locale and code set that the database was created in
- Format:
- locale.codeset@modifier
- odbc.ini field for UNIX:
- DB_LOCALE
- Default value for UNIX:
- en_us.8859-1
- Default value for Windows:
- en_us.1252
Important: The setting of the DB_LOCALE environment
variable in the operating system environment and in Setnet32 are ignored
by IBM Informix ODBC Driver.
To change the database locale, you must use this GLS option.
|
Translation library |
- Description:
- Performs the code set conversion
- Format:
- Path to the file for the library. The translation DLL must follow
the ODBC standard for translation libraries. For more information,
see the IBM Informix ODBC
Driver Programmer's Manual.
- odbc.ini field for UNIX:
- TRANSLATIONDLL
- Default value for UNIX:
- $INFORMIXDIR/lib/esql/igo4a304.xx where xx is
platform-specific extension for shared library
- Default value for Windows:
- igo4n304.dll
|
Translation option |
- Description:
- Option for a non-IBM Informix translation
library
- Format:
- Determined by the vendor
- odbc.ini field for UNIX:
- TRANSLATION_OPTION
- Default value for Windows:
- Determined by the vendor
Restriction: Do not set this option for
an IBM Informix translation
library. An IBM Informix translation
library determines the translation option based on the client locale
and database locale values.
|
VMB character |
- Description:
- Varying multibyte character length reporting option that specifies
how to set pcbValue when rgbValue (the output area)
is not large enough for the code-set-converted data. The possible
values are:
- Estimate
- IBM Informix ODBC Driver makes
a worst-case estimate of the storage space needed to return the data.
- Exact
- IBM Informix ODBC Driver writes
the code-set-converted data to disk until all the data is converted.
Because this option can degrade performance, it is recommended that
you do not use this option unless your application does not work with Estimate.
When you use a multibyte code set (in which characters
vary in length from 1 to 4 bytes) for either the database or client
locale, the length of a character string or simple large object (TEXT)
in the database locale does not indicate the length of the string
after it is converted to the client locale.
- Possible values for UNIX:
- 0 = Estimate
- 1 = Exact
- Possible values for Windows:
- Estimate
- Exact
- odbc.ini field for UNIX:
- VMBCHARLENEXACT
- Default value for UNIX:
- Estimate
- Default value for Windows:
- Estimate
|