Client EBCDIC to Server UNICODE | Teradata Vantage - 17.10 - Client EBCDIC to Server UNICODE - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

The following table shows how single-byte Latin characters from the EBCDIC client character set map to characters in the UNICODE server character set. The translation works both ways, from EBCDIC to UNICODE and from UNICODE to EBCDIC.

EBCDIC UNICODE Unicode Character Name
0x00 U+0000 <control> NULL
0x01 U+0001 <control> START OF HEADING
0x02 U+0002 <control> START OF TEXT
0x03 U+0003 <control> END OF TEXT
0x04 U+00A4 CURRENCY SIGN
0x05 U+0009 <control> CHARACTER TABULATION (horizontal tabulation)
0x06 U+00A9 COPYRIGHT SIGN
0x07 U+007F <control> DELETE
0x08 U+00D1 LATIN CAPITAL LETTER N WITH TILDE
0x09 U+00D2 LATIN CAPITAL LETTER O WITH GRAVE
0x0A U+00D3 LATIN CAPITAL LETTER O WITH ACUTE
0x0B U+000B <control> LINE TABULATION (vertical tabulation)
0x0C U+000C <control> FORM FEED
0x0D U+000D <control> CARRIAGE RETURN
0x0E U+000E <control> SHIFT OUT
0x0F U+000F <control> SHIFT IN
0x10 U+0010 <control> DATA LINK ESCAPE
0x11 U+0011 <control> DEVICE CONTROL ONE
0x12 U+0012 <control> DEVICE CONTROL TWO
0x13 U+0013 <control> DEVICE CONTROL THREE
0x14 U+00D4 LATIN CAPITAL LETTER O WITH CIRCUMFLEX
0x15 U+00D5 LATIN CAPITAL LETTER O WITH TILDE
0x16 U+0008 <control> BACKSPACE
0x17 U+00D6 LATIN CAPITAL LETTER O WITH DIAERESIS
0x18 U+0018 <control> CANCEL
0x19 U+0019 <control> END OF MEDIUM
0x1A U+0152 LATIN CAPITAL LIGATURE OE
0x1B U+00D8 LATIN CAPITAL LETTER O WITH STROKE
0x1C U+001C <control> INFORMATION SEPARATOR FOUR (file separator)
0x1D U+001D <control> INFORMATION SEPARATOR THREE (group separator)
0x1E U+001E <control> INFORMATION SEPARATOR TWO (record separator)
0x1F U+001F <control> INFORMATION SEPARATOR ONE (unit separator)
0x20 U+00E5 LATIN SMALL LETTER A WITH RING ABOVE
0x21 U+00E6 LATIN SMALL LETTER AE
0x22 U+00D9 LATIN CAPITAL LETTER U WITH GRAVE
0x23 U+00E7 LATIN SMALL LETTER C WITH CEDILLA
0x24 U+00E8 LATIN SMALL LETTER E WITH GRAVE
0x25 U+000A <control> LINE FEED
0x26 U+0017 <control> END OF TRANSMISSION BLOCK
0x27 U+001B <control> ESCAPE
0x28 U+00E9 LATIN SMALL LETTER E WITH ACUTE
0x29 U+00D0 LATIN CAPITAL LETTER ETH
0x2A U+00F1 LATIN SMALL LETTER N WITH TILDE
0x2B U+00F2 LATIN SMALL LETTER O WITH GRAVE
0x2C U+00F3 LATIN SMALL LETTER O WITH ACUTE
0x2D U+0005 <control> ENQUIRY
0x2E U+0006 <control> ACKNOWLEDGE
0x2F U+0007 <control> BELL
0x30 U+00F4 LATIN SMALL LETTER O WITH CIRCUMFLEX
0x31 U+00F5 LATIN SMALL LETTER O WITH TILDE
0x32 U+0016 <control> SYNCHRONOUS IDLE
0x33 U+00F6 LATIN SMALL LETTER O WITH DIAERESIS
0x34 U+0153 LATIN SMALL LIGATURE OE
0x35 U+00C9 LATIN CAPITAL LETTER E WITH ACUTE
0x36 U+00F8 LATIN SMALL LETTER O WITH STROKE
0x37 U+0004 <control> END OF TRANSMISSION
0x38 U+00F9 LATIN SMALL LETTER U WITH GRAVE
0x39 U+00E2 LATIN SMALL LETTER A WITH CIRCUMFLEX
0x3A U+00E3 LATIN SMALL LETTER A WITH TILDE
0x3B U+00E4 LATIN SMALL LETTER A WITH DIAERESIS
0x3C U+0014 <control> DEVICE CONTROL FOUR
0x3D U+0015 <control> NEGATIVE ACKNOWLEDGE
0x3E U+00E0 LATIN SMALL LETTER A WITH GRAVE
0x3F U+001A <control> SUBSTITUTE
0x40 U+0020 SPACE
0x41 U+00A8 DIAERESIS
0x42 U+00B4 ACUTE ACCENT
0x43 U+00B8 CEDILLA
0x44 U+00D7 MULTIPLICATION SIGN
0x45 U+00F7 DIVISION SIGN
0x46 U+0086 <control> START OF SELECTED AREA
0x47 U+0087 <control> END OF SELECTED AREA
0x48 U+0088 <control> CHARACTER TABULATION SET
0x49 U+0089 <control> CHARACTER TABULATION WITH JUSTIFICATION
0x4A U+008B <control> PARTIAL LINE FORWARD
0x4B U+002E FULL STOP
0x4C U+003C LESS-THAN SIGN
0x4D U+0028 LEFT PARENTHESIS
0x4E U+002B PLUS SIGN
0x4F U+008D <control> REVERSE LINE FEED
0x50 U+0026 AMPERSAND
0x51 U+0091 <control> PRIVATE USE ONE
0x52 U+0092 <control> PRIVATE USE TWO
0x53 U+0093 <control> SET TRANSMIT STATE
0x54 U+0094 <control> CANCEL CHARACTER
0x55 U+0095 <control> MESSAGE WAITING
0x56 U+0096 <control> START OF GUARDED AREA
0x57 U+0097 <control> END OF GUARDED AREA
0x58 U+0098 <control> START OF STRING
0x59 U+0099 <control>
0x5A U+0021 EXCLAMATION MARK
0x5B U+0024 DOLLAR SIGN
0x5C U+002A ASTERISK
0x5D U+0029 RIGHT PARENTHESIS
0x5E U+003B SEMICOLON
0x5F U+005E CIRCUMFLEX ACCENT
0x60 U+002D HYPHEN-MINUS
0x61 U+002F SOLIDUS
0x62 U+009B <control> CONTROL SEQUENCE INTRODUCER
0x63 U+009D <control> OPERATING SYSTEM COMMAND
0x64 U+00A2 CENT SIGN
0x65 U+00A3 POUND SIGN
0x66 U+00FD LATIN SMALL LETTER Y WITH ACUTE
0x67 U+00A5 YEN SIGN
0x68 U+00A6 BROKEN BAR
0x69 U+00A7 SECTION SIGN
0x6A U+007C VERTICAL LINE
0x6B U+002C COMMA
0x6C U+0025 PERCENT SIGN
0x6D U+005F LOW LINE
0x6E U+003E GREATER-THAN SIGN
0x6F U+003F QUESTION MARK
0x70 U+00C1 LATIN CAPITAL LETTER A WITH ACUTE
0x71 U+00C2 LATIN CAPITAL LETTER A WITH CIRCUMFLEX
0x72 U+00C3 LATIN CAPITAL LETTER A WITH TILDE
0x73 U+00C4 LATIN CAPITAL LETTER A WITH DIAERESIS
0x74 U+00C5 LATIN CAPITAL LETTER A WITH RING ABOVE
0x75 U+00C6 LATIN CAPITAL LETTER AE
0x76 U+00C7 LATIN CAPITAL LETTER C WITH CEDILLA
0x77 U+00C8 LATIN CAPITAL LETTER E WITH GRAVE
0x78 U+00A1 INVERTED EXCLAMATION MARK
0x79 U+0060 GRAVE ACCENT
0x7A U+003A COLON
0x7B U+0023 NUMBER SIGN
0x7C U+0040 COMMERCIAL AT
0x7D U+0027 APOSTROPHE
0x7E U+003D EQUALS SIGN
0x7F U+0022 QUOTATION MARK
0x80 U+00A0 NO-BREAK SPACE
0x81 U+0061 LATIN SMALL LETTER A
0x82 U+0062 LATIN SMALL LETTER B
0x83 U+0063 LATIN SMALL LETTER C
0x84 U+0064 LATIN SMALL LETTER D
0x85 U+0065 LATIN SMALL LETTER E
0x86 U+0066 LATIN SMALL LETTER F
0x87 U+0067 LATIN SMALL LETTER G
0x88 U+0068 LATIN SMALL LETTER H
0x89 U+0069 LATIN SMALL LETTER I
0x8A U+008A <control> LINE TABULATION SET
0x8B U+00C0 LATIN CAPITAL LETTER A WITH GRAVE
0x8C U+008C <control> PARTIAL LINE BACKWARD
0x8D U+00AD SOFT HYPHEN
0x8E U+008E <control> SINGLE SHIFT TWO
0x8F U+008F <control> SINGLE SHIFT THREE
0x90 U+0090 <control> DEVICE CONTROL STRING
0x91 U+006A LATIN SMALL LETTER J
0x92 U+006B LATIN SMALL LETTER K
0x93 U+006C LATIN SMALL LETTER L
0x94 U+006D LATIN SMALL LETTER M
0x95 U+006E LATIN SMALL LETTER N
0x96 U+006F LATIN SMALL LETTER O
0x97 U+0070 LATIN SMALL LETTER P
0x98 U+0071 LATIN SMALL LETTER Q
0x99 U+0072 LATIN SMALL LETTER R
0x9A U+009A <control> SINGLE CHARACTER INTRODUCER
0x9B U+00F0 LATIN SMALL LETTER ETH
0x9C U+009C <control> STRING TERMINATOR
0x9D U+00BD VULGAR FRACTION ONE HALF
0x9E U+009E <control> PRIVACY MESSAGE
0x9F U+009F <control> APPLICATION PROGRAM COMMAND
0xA0 U+0161 LATIN SMALL LETTER S WITH CARON
0xA1 U+007E TILDE
0xA2 U+0073 LATIN SMALL LETTER S
0xA3 U+0074 LATIN SMALL LETTER T
0xA4 U+0075 LATIN SMALL LETTER U
0xA5 U+0076 LATIN SMALL LETTER V
0xA6 U+0077 LATIN SMALL LETTER W
0xA7 U+0078 LATIN SMALL LETTER X
0xA8 U+0079 LATIN SMALL LETTER Y
0xA9 U+007A LATIN SMALL LETTER Z
0xAA U+00AA FEMININE ORDINAL INDICATOR
0xAB U+00AB LEFT-POINTING DOUBLE ANGLE QUOTATION MARK
0xAC U+00AC NOT SIGN
0xAD U+005B LEFT SQUARE BRACKET
0xAE U+00AE REGISTERED SIGN
0xAF U+00AF MACRON
0xB0 U+00B0 DEGREE SIGN
0xB1 U+00B1 PLUS-MINUS SIGN
0xB2 U+00B2 SUPERSCRIPT TWO
0xB3 U+00B3 SUPERSCRIPT THREE
0xB4 U+00DD LATIN CAPITAL LETTER Y WITH ACUTE
0xB5 U+00B5 MICRO SIGN
0xB6 U+00B6 PILCROW SIGN
0xB7 U+00B7 MIDDLE DOT
0xB8 U+0160 LATIN CAPITAL LETTER S WITH CARON
0xB9 U+00B9 SUPERSCRIPT ONE
0xBA U+00BA MASCULINE ORDINAL INDICATOR
0xBB U+00BB RIGHT-POINTING DOUBLE ANGLE QUOTATION MARK
0xBC U+00BC VULGAR FRACTION ONE QUARTER
0xBD U+005D RIGHT SQUARE BRACKET
0xBE U+00BE VULGAR FRACTION THREE QUARTERS
0xBF U+00BF INVERTED QUESTION MARK
0xC0 U+007B LEFT CURLY BRACKET
0xC1 U+0041 LATIN CAPITAL LETTER A
0xC2 U+0042 LATIN CAPITAL LETTER B
0xC3 U+0043 LATIN CAPITAL LETTER C
0xC4 U+0044 LATIN CAPITAL LETTER D
0xC5 U+0045 LATIN CAPITAL LETTER E
0xC6 U+0046 LATIN CAPITAL LETTER F
0xC7 U+0047 LATIN CAPITAL LETTER G
0xC8 U+0048 LATIN CAPITAL LETTER H
0xC9 U+0049 LATIN CAPITAL LETTER I
0xCA U+00CA LATIN CAPITAL LETTER E WITH CIRCUMFLEX
0xCB U+00CB LATIN CAPITAL LETTER E WITH DIAERESIS
0xCC U+00CC LATIN CAPITAL LETTER I WITH GRAVE
0xCD U+00CD LATIN CAPITAL LETTER I WITH ACUTE
0xCE U+00CE LATIN CAPITAL LETTER I WITH CIRCUMFLEX
0xCF U+00CF LATIN CAPITAL LETTER I WITH DIAERESIS
0xD0 U+007D RIGHT CURLY BRACKET
0xD1 U+004A LATIN CAPITAL LETTER J
0xD2 U+004B LATIN CAPITAL LETTER K
0xD3 U+004C LATIN CAPITAL LETTER L
0xD4 U+004D LATIN CAPITAL LETTER M
0xD5 U+004E LATIN CAPITAL LETTER N
0xD6 U+004F LATIN CAPITAL LETTER O
0xD7 U+0050 LATIN CAPITAL LETTER P
0xD8 U+0051 LATIN CAPITAL LETTER Q
0xD9 U+0052 LATIN CAPITAL LETTER R
0xDA U+00DA LATIN CAPITAL LETTER U WITH ACUTE
0xDB U+00DB LATIN CAPITAL LETTER U WITH CIRCUMFLEX
0xDC U+00DC LATIN CAPITAL LETTER U WITH DIAERESIS
0xDD U+0178 LATIN CAPITAL LETTER Y WITH DIAERESIS
0xDE U+00FE LATIN SMALL LETTER THORN
0xDF U+00DF LATIN SMALL LETTER SHARP S
0xE0 U+005C REVERSE SOLIDUS
0xE1 U+00E1 LATIN SMALL LETTER A WITH ACUTE
0xE2 U+0053 LATIN CAPITAL LETTER S
0xE3 U+0054 LATIN CAPITAL LETTER T
0xE4 U+0055 LATIN CAPITAL LETTER U
0xE5 U+0056 LATIN CAPITAL LETTER V
0xE6 U+0057 LATIN CAPITAL LETTER W
0xE7 U+0058 LATIN CAPITAL LETTER X
0xE8 U+0059 LATIN CAPITAL LETTER Y
0xE9 U+005A LATIN CAPITAL LETTER Z
0xEA U+00EA LATIN SMALL LETTER E WITH CIRCUMFLEX
0xEB U+00EB LATIN SMALL LETTER E WITH DIAERESIS
0xEC U+00EC LATIN SMALL LETTER I WITH GRAVE
0xED U+00ED LATIN SMALL LETTER I WITH ACUTE
0xEE U+00EE LATIN SMALL LETTER I WITH CIRCUMFLEX
0xEF U+00EF LATIN SMALL LETTER I WITH DIAERESIS
0xF0 U+0030 DIGIT ZERO
0xF1 U+0031 DIGIT ONE
0xF2 U+0032 DIGIT TWO
0xF3 U+0033 DIGIT THREE
0xF4 U+0034 DIGIT FOUR
0xF5 U+0035 DIGIT FIVE
0xF6 U+0036 DIGIT SIX
0xF7 U+0037 DIGIT SEVEN
0xF8 U+0038 DIGIT EIGHT
0xF9 U+0039 DIGIT NINE
0xFA U+00FA LATIN SMALL LETTER U WITH ACUTE
0xFB U+00FB LATIN SMALL LETTER U WITH CIRCUMFLEX
0xFC U+00FC LATIN SMALL LETTER U WITH DIAERESIS
0xFD U+00FF LATIN SMALL LETTER Y WITH DIAERESIS
0xFE U+00DE LATIN CAPITAL LETTER THORN
0xFF U+20AC EURO SIGN