Configuration

Home | Previous Page | Next Page Unicode > Using Unicode in an ODBC Application >

Configuration

Since the IBM Informix ODBC Driver supports different types of Unicode on UNIX platforms, the type of Unicode used by an application must be indicated in the ODBC section of the odbc.ini file as follows:

[ODBC]
.
.
.
UNICODE=UCS-4

On IBM AIX platforms with versions lower than 5L, the supported values for the UNICODE parameter is UCS-2. For all other UNIX platforms the supported values are UCS-4 and UTF-8.

Important:

A Unicode enabled application must indicate the type of Unicode used in the odbc.ini file. If the Unicode parameter is not set in odbc.ini, the default type is UCS-4.

It is required that all UNIX ODBC applications must set the Unicode type in the odbc.ini file as follows:

An ANSI ODBC application on UNIX must set UNICODE=UCS-4
An ANSI ODBC application on IBM AIX must set UNICODE-UCS-2
An ANSI ODBC application using the Data Direct (formerly Merant) ODBC driver manager should never indicate a Unicode type other than UTF-8 in the odbc.ini file.

The following table provides an overview of the odbc.ini settings:

Platform	Driver Manager	odbc.ini Setting
AIX	Data Direct	UTF-8
AIX	DMR or none	UCS-2
UNIX	Data Direct	UTF-8
UNIX	DMR or none	UCS-4
Windows	Windows ODBC Driver Manager	N/A