Home | Previous Page | Next Page   Internationalization and Date Formats >

Support for IBM Informix GLS Variables

Internationalization adds several environment variables to IBM Informix JDBC Driver, which are summarized in the following table. All internationalization properties are available on and optional for servers that support GLS.

Supported Informix Environment Variables Description
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.
DBCENTURY Enables you to specify the appropriate expansion for one- or two-digit year DATE values
DBDATE Specifies the end-user formats of values in DATE columns Supported for backward compatibility; GL_DATE is preferred.
DB_LOCALE Specifies the locale of the databaseIBM 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, 9.x, and 10.x.
NEWCODESET Allows new code sets to be defined between releases of IBM Informix JDBC Driver
NEWLOCALE Allows new locales to be defined between releases of IBM Informix JDBC Driver

Important:
The DB_LOCALE, CLIENT_LOCALE, and GL_DATE variables are supported only if the database server supports the IBM Informix GLS feature. If these environment variables are set and your application connects to a non-GLS server (server versions earlier than 7.2), a connection exception occurs. If you connect to a non-GLS server and do not set these variables, the behavior is the same as for older versions of IBM Informix JDBC Driver.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]