IANAAppCodePage

Supported on UNIX and Linux only.

Attribute

IANAAppCodePage (IACP)

Purpose

An Internet Assigned Numbers Authority (IANA) value. You must specify a value for this option if your application is not Unicode-enabled or if your database character set is not Unicode.

The driver uses the specified IANA code page to convert "W" (wide) functions to ANSI.

The driver and Driver Manager both check for the value of IANAAppCodePage in the following order:

• In the connection string
• In the Data Source section of the system information file (odbc.ini)
• In the ODBC section of the system information file (odbc.ini)

If the driver does not find an IANAAppCodePage value, the driver uses the default value of 4 (ISO 8859-1 Latin-1).

To override the value set by this connection option for an individual statement, set a different value in the SQL_ATTR_IANA_APP_CODE_PAGE statement attribute (attribute value 1064) on the SQLSetStmtAttr() function. This statement is defined in the qesqlext.h file, which is installed with the driver.

Valid Values

IANA_code_page

where:

IANA_code_page

is one of the valid values listed in IANAAppCodePage values in the Progress DataDirect for ODBC Drivers Reference. The value must match the database character encoding and the system locale.

Notes

• If your database is set to Unicode, specifying a value of 106 passes Unicode data to a your database without conversion. This value eliminates the need for ODBC function calls.

Default

4 (ISO 8559-1 Latin-1)

GUI Tab

Advanced tab

See Also

Refer to Internationalization, localization, and Unicode in the Progress DataDirect for ODBC Drivers Reference for details.