GLS-related environment variables
These topics list the GLS-related environment variables that you can set for IBM® Informix® database servers and SQL API products.
Important: Some previous releases of IBM
Informix supported
the GL_PATH environment variable. For all current
versions of ,
however, if you set GL_PATH before you initialize
the database server (or any SUID/SGID programs provided by ) you
get an error and its value is ignored.
- CC8BITLEVEL environment variable
The CC8BITLEVEL environment variable determines the type of processing that the IBM Informix ESQL/C filter, esqlmf, performs on non-ASCII (8-bit and multibyte) characters. - CLIENT_LOCALE environment variable
The CLIENT_LOCALE environment variable specifies the client locale, which the client application uses in read and write operations, display formats, and processing ESQL statements. - DBDATE environment variable (deprecated)
The DBDATE environment variable specifies the display formats of values in DATE columns. - DBLANG environment variable
The DBLANG environment variable specifies the subdirectory of INFORMIXDIR that contains the customized, language-specific message files that the IBM Informix product uses. - DB_LOCALE environment variable
The DB_LOCALE environment variable specifies the database locale, which the database server uses to process locale-sensitive data. - DBMONEY environment variable
The DBMONEY environment variable specifies the custom display formats for values in MONEY columns. - DBTIME environment variable (deprecated)
The DBTIME environment variable specifies the custom display formats of values in DATETIME columns for SQL API routines in the ESQL/C function libraries. - ESQLMF environment variable
The ESQLMF environment variable setting determines whether the esql command automatically starts the esqlmf multibyte filter. - GL_DATE environment variable
The GL_DATE environment variable specifies custom display formats of values for DATE columns. - GL_DATETIME environment variable
The GL_DATETIME environment variable specifies the custom display format of values in DATETIME columns. - GLS8BITFSYS environment variable
Use the GLS8BITFSYS environment variable to tell IBM Informix products (such as the Informix ESQL/C processor) whether the operating system is 8-bit clean. - GL_USEGLU environment variable
The GL_USEGLU environment variable enables GLS for Unicode (GLU). You must use the GL_USEGLU environment variable if you use NCHAR or NVARCHAR data types that require localized collation. - IFX_PUA_DISPLAY_MAPPING environment variable
Use the IFX_PUA_DISPLAY_MAPPING environment variable to set display widths for characters from the Unicode Private Use Area (PUA) ranges according to a mapping file that you supply: $INFORMIXIDR/gls/etc/pua.map. By default, DB-Access and other Informix character-based applications cannot interpret private-use characters. - SERVER_LOCALE environment variable
The SERVER_LOCALE environment variable specifies the server locale, which the database server uses to perform read and write operations that involve operating-system files on the server computer. - USE_DTENV environment variable
In a database where the GL_DATETIME environment variable has a nondefault setting, you cannot process localized DATETIME values correctly in some operations that load or unload data unless USE_DTENV is enabled.
Parent topic: GLS environment variables