ODBC Application Code Page Values (Linux/UNIX and Apple macOS) - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 macOS, 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

The following table 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