IBM-Compatible Japanese Character Sets

Teradata Database International Character Set Support

brand
Software
prodname
Teradata Database
vrm_release
15.00
15.10
category
Configuration
User Guide
featnum
B035-1125-015K

The term KanjiEBCDIC refers collectively to these character sets:

  • “KANJIEBCDIC5026_0I” on page 33
  • “KANJIEBCDIC5035_0I” on page 34
  • “KATAKANAEBCDIC” on page 35
  • These character sets emulate the IBM style, where the multibyte character sequence in a character string is bracketed by Shift-Out and Shift-In characters.

     

    Character Set Name

    CCSID1

    GCSGID2

    CPGID3

    Description

    KANJIEBCDIC5026_0I

    05026

    01172

    00290

    Single-byte

    00370

    00300

    Multibyte; 1880 user-defined characters

    KANJIEBCDIC5035_0I

    05035

    01172

    01027

    Single-byte

    00370

    00300

    Multibyte; 1880 user-defined characters

    KATAKANAEBCDIC

    13218

    00332

    00290

    Single-byte; no 'a'-'z'

    00370

    00300

    Multibyte; 1880 user-defined characters


    1
    Coded Character Set ID.

    2
    Character Set ID. Describes the permitted characters.

    3
    Code Page. Describes the encoding of the permitted characters.

     

    Hexadecimal Value

    Character

    Description

    0x10

    ¢

    Cent sign

    0x11

    £

    Pound Sterling currency symbol

    0x12

    ¬

    IBM logical NOT sign

    0x13

    \

    Backslash

    Because other translations map the values to control characters, they cannot be shared with other client character sets.

    Object names on systems enabled with Japanese language support can contain single-byte Latin and Katakana characters from the JIS X 0201 standard, and double-byte characters from the JIS X 0208 standard.

    For information on the rules and restrictions for naming Teradata Database objects, see the topics beginning with “About Object Names” on page 17.

    For additional rules and restrictions that apply to naming Teradata Database objects, see SQL Fundamentals.

    The following table shows where to find information on characters allowed in object names.

     

    IF the client character set is …

    THEN object names can contain single-byte Latin and Katakana characters shown in …

    AND double-byte characters shown in …

    KATAKANAEBCDIC

    “EBCDIC KATAKANA Character Set” on page 155.

    the following shaded areas in “EBCDIC Kanji Character Set” on page 159:

  • IBM Extended non-Kanji
  • IBM Basic Kanji
  • IBM Extended Kanji
  • KANJIEBCDIC5026_0I

    “EBCDIC Japanese Extended Katakana Character Set” on page 156.

    KANJIEBCDIC5035_0I

    “EBCDIC Japanese Extended English Character Set” on page 158.

    Double-byte characters in the User and Marker areas in “EBCDIC Kanji Character Set” on page 159 are not valid for object names. Additionally, double-byte characters in the following table are not in JIS X 0208 and are not valid for object names under KANJIEBCDIC5026_0I, KANJIEBCDIC5035_0I, and KATAKANAEBCIDC.

     

    First Byte

     

     

     

     

     

    Second Byte

     

     

     

     

     

     

     

    0x40

    40

    0x41

    41 - FE

    0x42

    41 - 6C

    6E - 7A

    7C - 80

    AA - C0

    EA - EF

    FA - FE

    0x43

     

    41 - 45

    4A - 4F

    5B - 7A

    7C - 7F

    A1

    B0 - B9

    DC - DD

    E0 - F2

    0x44

    42 - 45

    4A - 4E

    50

    5A - 7F

    DC - DD

    E0 - F3

    0x51

    BF

    DA

    F7

    0x52

    4B

    7B

    94

    9E

    EB

    0x53

    86

    94

    97

    C7

    0x56

     

    44

    5D

    62

    65 - 66

    6A

    6E

    70 - 71

    74

    7B

    86

    8A

    91

    94

    98

    A2 - A4

    A8

    B2

    B5

    C9

    CE

    DC

    E8

    EF

    F7

    0x57

     

    4F

    50

    56

    58

    61

    63

    6B

    7C

    80

    87

    8B

    8E

    A9

    AE

    BD

    C0

    DE

    0x58

     

    60

    63

    6C

    70

    73

    77

    82

    8A

    8C

    A1

    AD

    B0

    B1 - B2

    BE

    C0

    EC

    FC

    FE

    0x59

     

    42

    44

    51

    67 - 68

    70

    78

    7F

    80

    84

    87

    93

    95

    97

    C7

    CB

    D8

    E8

    F1

    0x5A

    44

    51

    57

    5F

    65

    67 - 68

    76

    79

    7E

    94

    B5

    DA

    FB

    0x5B

     

    50

    53 - 54

    7E

    97 - 99

    9D

    A0 - A1

    A4

    A7 - A8

    AB

    F9

    AE - AF

    B4

    B6

    B8

    BB

    C7 - C9

    D8

    E3

    EC

    F0

    F3

    0x5C

     

    5F

    66

    6E

    78 - 79

    90

    9A - 9B

    A6

    A9

    AF

    B9

    BC

    EA

    F6

    F9

    FD - FE

    0x5D

     

    4E

    58

    60

    62

    6B

    72

    74

    7A

    7F

    80

    8A

    8E

    93

    95

    A6

    C1

    CA

    D5

    D7 - D8

    E3

    EA

    ED

    F5 - F6

    FB - FD

    0x5E

     

    49

    4B

    5A

    73

    75

    86

    8A

    94

    99

    9E - 9F

    A1 - A2

    A7 - A8

    AA - AB

    AD - AE

    BC - BD

    C0

    D1

    E7

    0x5F

     

    69

    70 - 73

    7A

    8E

    AA

    AE

    B2 - B3

    B6

    D1 - D2

    D5

    D9

    DC - DD

    DF

    0x60

    4F

    58 - 5A

    82

    AD

    C4

    C6

    D4

    DA

    E1

    FD

    0x61

    57

    6E

    77

    F8

    0x62

    48

    5B

    67

    74

    7E

    8A

    9E

    A1

    A8

    B9

    BB

    CE

    E2

    0x63

    5E

    90

    C5

    CB

    D4

    DF

    E1

    ED - EF

    0x64

    45

    50

    7C - 7D

    85

    8D - 8E

    C9

    F1

    0x65

     

     

     

    49

    53

    64

    66 - 67

    6B

    83

    85 - 86

    8A

    8C - 8D

    8F

    90

    93

    95

    9B

    9E - 9F

    A1

    A3

    A5 - A6

    A8

    AB - AD

    B4 - B9

    BC - BD

    C1

    C3

    C5 - C6

    C8 - C9

    CC

    CE

    D0

    D5

    D8

    DD

    E4

    E8

    F0

    F4

    F6

    0x66

     

    4A

    74

    78 - 79

    7F

    97

    99

    9E

    A2 - A5

    CB - CC

    DD

    DF

    E5 - E6

    F9

    0x67

    59

    6B - 6C

    8F

    91

    93

    9B

    9F

    B1

    E2

    E4

    F4

    FE

    0x68

    56