Platform SDK: SNA Server

ISO Code Page Support Using the ODBC Driver for DB2

DB2 Universal Database for AIX systems are frequently configured for an ISO code page, for example ISO 819 (Latin I). SNA Server 4.0 with Service Pack 3 and later includes support for some ISO code pages for purposes of ISO-to-UNICODE-to-ANSI, ANSI-to-UNICODE-to-ISO, and ISO-to-UNICODE-to-ISO conversions.. These ISO code pages can be used when accessing DB2 Universal Database on AIX.

Depending on the version of Microsoft Windows you're using, you may need to install the appropriate ISO National Language Support (NLS) file for your locale to support ISO-to-UNICODE-to-ANSI (Windows), ANSI-to-UNCODE-to-ISO, and ISO-to-UNICODE-to-ISO code page conversions.

On Windows NT 4.0, the appropriate ISO NLS file for your locale is installed automatically when you install a localized version of Windows NT or when you install the Windows NT Language Pack on a nonlocalized version of Windows NT.

On Windows 95 and Windows 98, the appropriate ISO NLS file for your locale is installed automatically when you install a localized version of Windows 95 or Windows 98.

On Windows 2000, the appropriate ISO NLS file for your locale is installed automatically when you install a localized version of Windows 2000.

The following table shows the ISO character code set identifiers (CCSIDs) supported by the ODBC Driver for DB2 in SNA Server 4.0 with Service Pack 3 and later.

Microsoft Display Name Microsoft NLS Code Page IBM CCSID Source of the NLS file
ISO 8859-1 Latin 1 28591 819 Installed with SNA Server client on Windows NT, Windows 95, and Windows 98.
Installed as part of the operating system on Windows 2000.
ISO 8859-2 Central Europe 28592 912 European Language Pack
ISO 8859-5 Cyrillic 28595 915 Cyrillic Language Pack
ISO 8859-6 Arabic 28596 1089 Arabic Language Pack
ISO 8859-7 Greek 28597 813 Greek Language Pack
ISO 8859-8 Hebrew 28598 916 Hebrew Language Pack
ISO 8859-9 Turkish 28599 920 European Language Pack
ISO 6937 Non-Spacing Accent 20269 819 European Language Pack

The Microsoft Display Name is the name found in the Windows NT Language Pack definitions for these NLS files.

The Microsoft NLS Code Page represents the code page number that is registered and associated with an ISO-to-UNICODE NLS resource file. The Microsoft NLS number should be set as the Host CCSID when configuring ODBC data sources or ODBC file DSNs. When setting the Host CCSID or PC Code Page attribute/property using a connection string, the Microsoft NLS number should be used for this parameter.

The IBM CCSID column represents the CCSID given to the ISO code page in IBM publications. IBM lists their ISO support in publications by referencing the locale name (Bulgaria for ISO8859-5 and 915, for example) rather than simply using ISO 8859-5 Cyrillic as used by Microsoft. The ODBC Driver for DB2 does not recognize or display the IBM CCSID values when configuring ODBC data sources. The ODBC Driver for DB2 maps the Microsoft NLS numbers to ISO NLS files, which correspond with the appropriate IBM CCSID numbers.

Note that IBM CCSID 819 is associated with both ISO 8859-1 Latin 1 and ISO 6937 Non-Spacing Accent. It is up to the user to choose the standard ISO 8859-1 Latin 1 code page by selecting NLS code page 28591 or the modified code page ISO 6937 Non-Spacing Accent by selecting NLS code page 20269.

IBM CCSID 916 (ISO 8859-8) supports Hebrew with visual sort order. IBM CCSID 920 (ISO 8859-8 derivation) supports Hebrew with logical sort order. Although Microsoft supports the logical sort order with NLS 38598, this NLS file is only distributed with Microsoft Internet Explorer 5.0 or Windows 2000. The ODBC Driver for DB2 has not been tested using the ISO 8859-8 derivation matching IBM CCSID 920 and does not support this configuration.

These are the only ISO pages currently supported in SNA 4.0 with Service Pack 3 or later. Microsoft supports a number of additional ISO pages. IBM also supports additional ISO pages. However, the code pages listed in the table above are the only cases where the Microsoft NLS pages and IBM CCSIDs match.