Internationalization

Internationalization adds several environment variables to IBM Informix JDBC Driver.

To set the JDBC Driver environment variables:

Choose Tools -> Connection manager top-level menu

1. From the dropdown list, select connection for which you want to set up the environment variables.
2. Switch to Database tab and press Advanced button.
3. Select the environment variable, which you want to edit in the list.
4. Enter the value in the editable field under the list and press Set button.
5. Close the Environment window.

CLIENT_LOCALE Specifies the locale of the client that is accessing the database. Provides defaults for user-defined formats such as the GL_DATE format. User-defined data types can use it for code-set conversion. Together with the DB_LOCALE variable, the database server uses this variable to establish the server processing locale. The DB_LOCALE and CLIENT_LOCALE values must be the same, or their code sets must be convertible. To find the current value of your database locale, execute the following query against the sysmaster database on your server:

                             SELECT * from sysmaster:sysdbslocale

DB_LOCALE Specifies the locale of the database. Informix JDBC Driver uses this variable to perform code set conversion between

Unicode and the database locale. Together with the CLIENT_LOCALE variable, the database server uses this variable to establish the server processing locale. The DB_LOCALE and CLIENT_LOCALE values must be the same, or their code sets must be convertible.

GL_DATE Specifies the end-user formats of values in DATE columns. This variable is supported in Informix database server versions 7.2x, 8.x, and 9.x.

DBCENTURY Enables you to specify the appropriate expansion for one or two-digit year DATE values.