PREVNEXTINDEX
 

G Values for IANAAppCodePage Connection String Attribute


You need to set the IANAAppCodePage connection string attribute (see "Connecting Using a Connection String") if your application is not Unicode-enabled and/or if your database character set is not Unicode. The value you specify must match the database character encoding and the system locale. See Appendix F "Internationalization, Localization, and Unicode" for information about Unicode.

To determine the correct numeric value (the MIBenum value) for the IANAAppCodePage connection string attribute, use the ivcheckcp utility (see "Using the ivcheckcp Utility").

Alternatively, do the following:

  1. Determine the code page of your database.
  2. Determine the MIBenum value that corresponds to your database code page. You can check the value at:
  3. http://www.iana.org/assignments/character-sets

    On this web page, search for the name of your database code page. This name will be listed as an alias or the name of a character set and will have a MIBenum value associated with it.

  4. Check Table G-1 to make sure that the MIBenum value you looked up on the IANA Web page is supported by SequeLink Client for ODBC. If the value is not listed, contact SupportLink to request that support for that value be added.

The appendix contains the following sections:

Using the ivcheckcp Utility

The ivcheckcp utility, located in the installdir/tools subdirectory, checks the codepage of your system and displays the locale, code page, iananame and IANAAppCodePage. The IANAAppCodePage number is the transliteration configuration parameter for the DataDirect Driver Manager on UNIX.

Check Table G-1 in this appendix to make sure that the IANAAppCodePage value you looked up on the IANA Web page is supported by SequeLink Client for ODBC. If the value is not listed, contact SupportLink to request that support for that value be added.

The syntax of this command is

ivcheckcp <locale> 

Example 1 (on AIX)

$ ./ivcheckcp en_US.ISO8859-1 
                  locale         codepage         iananame IANAAppCodePage 
         en_US.ISO8859-1        ISO8859-1       ISO-8859-1 4 

Example 2 (on AIX)

$ ./ivcheckcp `locale -a` 
                  locale         codepage         iananame IANAAppCodePage 
                       C        ISO8859-1       ISO-8859-1 4 
                   POSIX        ISO8859-1       ISO-8859-1 4 
                   en_US        ISO8859-1       ISO-8859-1 4 
           en_US.8859-15       ISO8859-15       ISO-8859-15 111 
         en_US.ISO8859-1        ISO8859-1       ISO-8859-1 4 

Example 3 (on z/OS)

                  locale         codepage         iananame IANAAppCodePage 
         en_US.ISO8859-1         IBM-1047          IBM1047 2102            

IANAAppCodePageValues

Table G-1 lists supported values, along with a description, for the IANAAppCodePage connection string attribute at the time of this publication. Support for additional values may have been added since publication time; therefore, for up-to-date values, go to:

http://www.datadirect.com/support/troubleshooting/su-faq-iana/index.ssp

Table G-1. IANAAppCodePage Values 
Value (MIBenum)
Description
3
US_ASCII
4
ISO_8859_1
5
ISO_8859_2
6
ISO_8859_3
8
ISO_8859_5
9
ISO_8859_6
10
ISO_8859_7
11
ISO_8859_8
12
ISO_8859_9
17
Shift_JIS
18
EUC_JP
38
EUC_KR
106
UTF-8
109
ISO_8859_13
111
ISO_8859_15
113
GBK
2004
HP_ROMAN8
2009
IBM850
2025
GB2312
2026
Big5
2084
KOI8_R
2088
KOI8_U
2251
WINDOWS_1251
2252
WINDOWS_1252
2258
WINDOWS_1258
2259
TIS_620
10001
IBM-856
10003
IBM-921
10004
IBM-922
10012
IBM-943
10024
IBM-1046
10030
IBM-1124

Supported Code Pages on Solaris

Table G-2 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 5.5 or higher for ODBC on the Solaris platform.

Table G-2. Code Pages Supported on Solaris 
Code page
IANA Character Set Name
IANAAppCodePage
646
US_ASCII
3
ISO8859-1
ISO_8859_1
4
ISO8859-2
ISO_8859_2
5
ISO8859-5
ISO_8859_5
8
ISO8859-6
ISO_8859_6
9
ISO8859-7
ISO_8859_7
10
ISO8859-8
ISO_8859_8
11
ISO8859-9
ISO_8859_9
12
PCK
Shift_JIS
17
eucJP
EUC_JP
18
ISO8859-13
ISO_8859_13
109
ISO8859-15
ISO_8859_15
111
GBK
GBK
113
UTF-8
UTF-8
106
gb2312
GB2312
2025
BIG5
Big5
2026
KOI8-R
KOI8_R
2084
TIS620.2533
TIS_620
2259

Supported Code Pages on HP

Table G-3 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 5.5 or higher for ODBC on the HP-UX platform.

Table G-3. Code Pages Supported on HP-UX 
Code page
IANA Character Set Name
IANAAppCodePage
iso88591
ISO_8859_1
4
iso88592
ISO_8859_2
5
iso88595
ISO_8859_5
8
iso88596
ISO_8859_6
9
iso88597
ISO_8859_7
10
iso88598
ISO_8859_8
11
iso88599
ISO_8859_9
12
utf8
UTF-8
106
big5
Big5
2026
tis620
TIS_620
2259
roman8
HP_ROMAN8
2004

Supported Code Pages on AIX

Table G-4 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 5.5 or higher for ODBC on the AIX platform.

Table G-4. Code Pages Supported on AIX 
Code Page
IANA Character Set Name
IANAAppCodePage
kIANACS_MIB_US_ ASCII
US_ASCII
3
ISO8859-1
ISO_8859_1
4
ISO8859-2
ISO_8859_2
5
ISO8859-5
ISO_8859_5
8
ISO8859-6
ISO_8859_6
9
ISO8859-7
ISO_8859_7
10
ISO8859-8
ISO_8859_8
11
ISO8859-9
ISO_8859_9
12
IBM-eucJP
EUC_JP
18
IBM-eucKR
EUC_KR
38
ISO8859-15
ISO_8859_15
111
GBK
GBK
113
UTF-8
UTF-8
106
IBM-850
IBM-850
2009
big5
Big5
2026
IBM-1252
WINDOWS_1252
2252
TIS-620
TIS_620
2259
IBM-856
IBM-856
10001
IBM-921
IBM-921
10003
IBM-922
IBM-922
10004
IBM-943
IBM-943
10012
IBM-1046
IBM-1046
10024
IBM-1124
IBM-1124
10030

Supported Code Pages on Linux

Table G-5 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 5.5 or higher for ODBC on the Linux platform.

Table G-5. Code Pages Supported on Linux 
Code Page
IANA Character set name
IANAAppCodePage
ANSI_X3.4-1968
US_ASCII
3
ISO-8859-1
ISO_8859_1
4
ISO-8859-2
ISO_8859_2
5
ISO-8859-3
ISO_8859_3
6
ISO-8859-5
ISO_8859_5
8
ISO-8859-5
ISO_8859_6
9
ISO-8859-7
ISO_8859_7
10
ISO-8859-8
ISO_8859_8
11
ISO-8859-9
ISO_8859_9
12
EUC-JP
EUC_JP
18
EUC-KR
EUC_KR
38
ISO-8859-13
ISO_8859_13
109
ISO-8859-15
ISO_8859_15
111
GBK
GBK
113
GB18030
GB18030
114
UTF-8
UTF-8
106
GB2312
2025 GB2312
2025
BIG5
Big5
2026
KOI8-R
KOI8_R
2084
KOI8-U
KOI8-U
2088
CP1251
WINDOWS_1251
2251
TIS-620
TIS_620
2259

Supported Code Pages on Windows

Table G-6 lists supported code pages, code page name, MIBenum value, and IANA character set name for the SequeLink Client 5.5 or higher for ODBC on the Windows platform.

Table G-6. Code Pages Supported on Windows 
Codepage
Codepage Name
MIBenum
IANA Character Set Name
932
Japanese Shift-JIS
17
Shift_JIS
936
Simplified Chinese GBK
113
GBK
949
Korean
10015
WINDOWS_949
1250
Central Europe
2250
WINDOWS_1251
1250
Central Europe
2250
WINDOWS_1251
1251
Cyrillic
2251
WINDOWS_1251
1252
Latin I
2252
WINDOWS_1252
1253
Greek
2253
WINDOWS_1253
1254
Turkish
2254
WINDOWS_1254
1255
Hebrew
2255
WINDOWS_1255
1256
Arabic
2256
WINDOWS_1256
1257
Baltic
2257
WINDOWS_1257
1258
Vietnam
2258
WINDOWS_1258


PREVNEXTINDEX