The ODBC Driver Manager handles the conversion needed when an ANSI application calls the Unicode ODBC driver.
ODBC Application Code Page Values (Linux/UNIX and Apple OS X)
ODBC application code page values can be set either in the DSN or the connection string. Any setting in the connection string takes precedence over settings in the DSN.
On Apple OS X, only the following code page value is supported due to a restriction imposed by iODBC Driver Manager:
|
ODBC Application Code Page Value |
Description |
|
4 |
ISO 8859-1 Latin-1 |
Table 42 lists ODBC application code page values used in ODBC Driver for Teradata on a Linux/UNIX system.
|
ODBC Application Code Page Values |
Description |
|
3 |
ISO 646 7-bit ASCII |
|
4 |
ISO 8859-1 Latin-1 |
|
2009 |
CP 850 - European code page |
|
2011 |
CP 437 - US code page |
|
2004 |
HP ROMANS |
|
2027 |
Standard Macintosh Roman |
|
17 |
Shift-JIS proper |
|
18 |
EUC-JIS encoding |
|
2025 |
EUC-CNS encoding |
|
2024 |
Microsoft CP 932 = Win32J-DBCS |
|
5 |
ISO 8859-2 Latin-2 Eastern Europe |
|
8 |
ISO 8859-5 Latin/Cyrillic |
|
9 |
ISO 8859-6 Latin/Arabic |
|
10 |
ISO 8859-7 Latin/Greek |
|
11 |
ISO 8859-8 Latin/Hebrew |
|
12 |
ISO 8859-9 Latin-5 Turkish |
|
13 |
ISO 8859-10 Latin-6 Nordic |
|
6 |
ISO 8859-3 Latin/Esperanto/Galician |
|
7 |
ISO 8859-4 Latin/Estonian/Latvian |
|
16 |
JIS_Encoding |
|
30 |
ISO_646_IRV |
|
37 |
ISO_2022_KR |
|
38 |
EUC_KR |
|
39 |
ISO_2022_IP |
|
40 |
ISO_2022_IP_2 |
|
57 |
GB_2312_80 |
|
104 |
ISO_2022_CN |
|
105 |
ISO_2022_CN_EXT |
|
109 |
ISO 8859-13 |
|
110 |
ISO 8859-14 |
|
111 |
ISO 8859-15 Latin-9 Western Europe with Euro sign |
|
2084 |
KOI8 - Cyrillic |
|
2259 |
TIS 620 - Thai standard |
|
2026 |
Big5 Traditional Chinese |
|
2028 |
IBM EBCDIC (8859-1 convertible) |
|
2030 |
IBM EBCDIC Germany/Austria |
|
2033 |
IBM EBCDIC Denmark/Norway |
|
2034 |
IBM EBCDIC Finland/Sweden |
|
2035 |
IBM280 |
|
2037 |
IBM EBCDIC Spain/Latin America |
|
2038 |
IBM EBCDIC U.K. |
|
2039 |
IBM EBCDIC Katakana for DB2 |
|
2040 |
IBM EBCDIC France |
|
2041 |
IBM EBCDIC Arabic bilingual |
|
2043 |
IBM424 |
|
2044 |
IBM EBCDIC Western Europe |
|
2045 |
IBM851 |
|
2010 |
PC Eastern Europe |
|
2046 |
PC Cyrillic |
|
2047 |
PC Turkish |
|
2048 |
PC Portuguese |
|
2049 |
PC Icelandic |
|
2050 |
PC Canadian French |
|
2051 |
PC Arabic |
|
2052 |
PC Nordic |
|
2054 |
PC Greek |
|
2055 |
IBM EBCDIC Eastern Europe |
|
111 |
Microsoft Thai SB code page |
|
17 |
Japanese IBM J-DBCS: CP 897 + CP 301 |
|
113 |
PC Simplified Chinese |
|
36 |
PC (MS) Korean, similar to EUC-KSC |
|
2026 |
PC (MS) Traditional Chinese (~Big5) |
|
18 |
EUC-JIS |
|
3063 |
IBM EBCDIC Turkish |
|
2056 |
IBM871 |
|
2062 |
IBM918 |
|
2063 |
IBM1026 |
|
2085 |
HZ_GB_2312 |
|
2086 |
IBM866 |
|
2087 |
IBM775 |
|
2089 |
IBM00858 |
|
2091 |
IBM01140 |
|
2092 |
IBM01141 |
|
2093 |
IBM01142 |
|
2094 |
IBM01143 |
|
2095 |
IBM01144 |
|
2096 |
IBM01145 |
|
2097 |
IBM01146 |
|
2098 |
IBM01147 |
|
2099 |
IBM01148 |
|
2100 |
IBM01149 |
|
2102 |
z/OS Open Edition |
|
2250 |
MS Windows 3.1 Eastern European |
|
2251 |
MS Windows 3.1 Cyrillic |
|
2252 |
MS Windows 3.1 US (ANSI) |
|
2253 |
MS Windows 3.1 Greek |
|
2254 |
MS Windows 3.1 Turkish |
|
2255 |
MS Windows Hebrew |
|
2256 |
MS Windows Arabic |
|
2257 |
MS Windows Baltic |
|
2258 |
MS Windows Vietnamese |