15.10 - Application Code Page - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

The ODBC Driver Manager handles the conversion needed when an ANSI application calls the Unicode ODBC driver.

  • On a UNIX system, the Driver Manager uses the ODBC application code page setting in the DSN or connection string when converting an ANSI string argument passed to the ANSI ODBC function calls to or from Unicode. An example of this conversion is when an ANSI application calls SQLExecDirect.
  • On a UNIX system, ODBC Driver for Teradata uses the ODBC application code page specified in the DSN or connection string for conversions to and from Unicode. These conversions are done for data that is bound with the SQL_C_CHAR type.
  • On Windows, the Driver Manager uses the Windows application code page when converting to or from Unicode.
  • On Apple OS X, the ODBC driver manager uses the current locale LC_TYPE category when converting to or from Unicode.
  • 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.

     

    Table 42: ODBC Application Code Page Values 

    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