Client ASCII to Server UNICODE | Teradata Vantage - 17.10 - Client ASCII 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 Teradata Database maps Latin characters from the ASCII client character set to the UNICODE server character set. The translation works in both directions, from ASCII to UNICODE and from UNICODE to ASCII.

ASCII UNICODE Latin 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+0004 <control> END OF TRANSMISSION
0x05 U+0005 <control> ENQUIRY
0x06 U+0006 <control> ACKNOWLEDGE
0x07 U+0007 <control> BELL
0x08 U+0008 <control> BACKSPACE
0x09 U+0009 <control> CHARACTER TABULATION (horizontal tabulation)
0x0A U+000A <control> LINE FEED
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+0014 <control> DEVICE CONTROL FOUR
0x15 U+0015 <control> NEGATIVE ACKNOWLEDGE
0x16 U+0016 <control> SYNCHRONOUS IDLE
0x17 U+0017 <control> END OF TRANSMISSION BLOCK
0x18 U+0018 <control> CANCEL
0x19 U+0019 <control> END OF MEDIUM
0x1A U+001A <control> SUBSTITUTE
0x1B U+001B <control> ESCAPE
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+0020 SPACE
0x21 U+0021 EXCLAMATION MARK
0x22 U+0022 QUOTATION MARK
0x23 U+0023 NUMBER SIGN
0x24 U+0024 DOLLAR SIGN
0x25 U+0025 PERCENT SIGN
0x26 U+0026 AMPERSAND
0x27 U+0027 APOSTROPHE
0x28 U+0028 LEFT PARENTHESIS
0x29 U+0029 RIGHT PARENTHESIS
0x2A U+002A ASTERISK
0x2B U+002B PLUS SIGN
0x2C U+002C COMMA
0x2D U+002D HYPHEN-MINUS
0x2E U+002E FULL STOP
0x2F U+002F SOLIDUS
0x30 U+0030 DIGIT ZERO
0x31 U+0031 DIGIT ONE
0x32 U+0032 DIGIT TWO
0x33 U+0033 DIGIT THREE
0x34 U+0034 DIGIT FOUR
0x35 U+0035 DIGIT FIVE
0x36 U+0036 DIGIT SIX
0x37 U+0037 DIGIT SEVEN
0x38 U+0038 DIGIT EIGHT
0x39 U+0039 DIGIT NINE
0x3A U+003A COLON
0x3B U+003B SEMICOLON
0x3C U+003C LESS-THAN SIGN
0x3D U+003D EQUALS SIGN
0x3E U+003E GREATER-THAN SIGN
0x3F U+003F QUESTION MARK
0x40 U+0040 COMMERCIAL AT
0x41 U+0041 LATIN CAPITAL LETTER A
0x42 U+0042 LATIN CAPITAL LETTER B
0x43 U+0043 LATIN CAPITAL LETTER C
0x44 U+0044 LATIN CAPITAL LETTER D
0x45 U+0045 LATIN CAPITAL LETTER E
0x46 U+0046 LATIN CAPITAL LETTER F
0x47 U+0047 LATIN CAPITAL LETTER G
0x48 U+0048 LATIN CAPITAL LETTER H
0x49 U+0049 LATIN CAPITAL LETTER I
0x4A U+004A LATIN CAPITAL LETTER J
0x4B U+004B LATIN CAPITAL LETTER K
0x4C U+004C LATIN CAPITAL LETTER L
0x4D U+004D LATIN CAPITAL LETTER M
0x4E U+004E LATIN CAPITAL LETTER N
0x4F U+004F LATIN CAPITAL LETTER O
0x50 U+0050 LATIN CAPITAL LETTER P
0x51 U+0051 LATIN CAPITAL LETTER Q
0x52 U+0052 LATIN CAPITAL LETTER R
0x53 U+0053 LATIN CAPITAL LETTER S
0x54 U+0054 LATIN CAPITAL LETTER T
0x55 U+0055 LATIN CAPITAL LETTER U
0x56 U+0056 LATIN CAPITAL LETTER V
0x57 U+0057 LATIN CAPITAL LETTER W
0x58 U+0058 LATIN CAPITAL LETTER X
0x59 U+0059 LATIN CAPITAL LETTER Y
0x5A U+005A LATIN CAPITAL LETTER Z
0x5B U+005B LEFT SQUARE BRACKET
0x5C U+005C REVERSE SOLIDUS
0x5D U+005D RIGHT SQUARE BRACKET
0x5E U+005E CIRCUMFLEX ACCENT
0x5F U+005F LOW LINE
0x60 U+0060 GRAVE ACCENT
0x61 U+0061 LATIN SMALL LETTER A
0x62 U+0062 LATIN SMALL LETTER B
0x63 U+0063 LATIN SMALL LETTER C
0x64 U+0064 LATIN SMALL LETTER D
0x65 U+0065 LATIN SMALL LETTER E
0x66 U+0066 LATIN SMALL LETTER F
0x67 U+0067 LATIN SMALL LETTER G
0x68 U+0068 LATIN SMALL LETTER H
0x69 U+0069 LATIN SMALL LETTER I
0x6A U+006A LATIN SMALL LETTER J
0x6B U+006B LATIN SMALL LETTER K
0x6C U+006C LATIN SMALL LETTER L
0x6D U+006D LATIN SMALL LETTER M
0x6E U+006E LATIN SMALL LETTER N
0x6F U+006F LATIN SMALL LETTER O
0x70 U+0070 LATIN SMALL LETTER P
0x71 U+0071 LATIN SMALL LETTER Q
0x72 U+0072 LATIN SMALL LETTER R
0x73 U+0073 LATIN SMALL LETTER S
0x74 U+0074 LATIN SMALL LETTER T
0x75 U+0075 LATIN SMALL LETTER U
0x76 U+0076 LATIN SMALL LETTER V
0x77 U+0077 LATIN SMALL LETTER W
0x78 U+0078 LATIN SMALL LETTER X
0x79 U+0079 LATIN SMALL LETTER Y
0x7A U+007A LATIN SMALL LETTER Z
0x7B U+007B LEFT CURLY BRACKET
0x7C U+007C VERTICAL LINE
0x7D U+007D RIGHT CURLY BRACKET
0x7E U+007E TILDE
0x7F U+007F <control> DELETE
0x80 U+00A0 NO-BREAK SPACE
0x81 U+00A8 DIAERESIS
0x82 U+00B4 ACUTE ACCENT
0x83 U+00B8 CEDILLA
0x84 U+00D7 MULTIPLICATION SIGN
0x85 U+00F7 DIVISION SIGN
0x86 U+0086 <control> START OF SELECTED AREA
0x87 U+0087 <control> END OF SELECTED AREA
0x88 U+0088 <control> CHARACTER TABULATION SET
0x89 U+0089 <control> CHARACTER TABULATION WITH JUSTIFICATION
0x8A U+008A <control> LINE TABULATION SET
0x8B U+008B <control> PARTIAL LINE FORWARD
0x8C U+008C <control> PARTIAL LINE BACKWARD
0x8D U+008D <control> REVERSE LINE FEED
0x8E U+008E <control> SINGLE SHIFT TWO
0x8F U+008F <control> SINGLE SHIFT THREE
0x90 U+0090 <control> DEVICE CONTROL STRING
0x91 U+0091 <control> PRIVATE USE ONE
0x92 U+0092 <control> PRIVATE USE TWO
0x93 U+0093 <control> SET TRANSMIT STATE
0x94 U+0094 <control> CANCEL CHARACTER
0x95 U+0095 <control> MESSAGE WAITING
0x96 U+0096 <control> START OF GUARDED AREA
0x97 U+0097 <control> END OF GUARDED AREA
0x98 U+0098 <control> START OF STRING
0x99 U+0099 <control>
0x9A U+009A <control> SINGLE CHARACTER INTRODUCER
0x9B U+009B <control> CONTROL SEQUENCE INTRODUCER
0x9C U+009C <control> STRING TERMINATOR
0x9D U+009D <control> OPERATING SYSTEM COMMAND
0x9E U+009E <control> PRIVACY MESSAGE
0x9F U+009F <control> APPLICATION PROGRAM COMMAND
0xA0 U+0161 LATIN SMALL LETTER S WITH CARON
0xA1 U+00A1 INVERTED EXCLAMATION MARK
0xA2 U+00A2 CENT SIGN
0xA3 U+00A3 POUND SIGN
0xA4 U+00FD LATIN SMALL LETTER Y WITH ACUTE
0xA5 U+00A5 YEN SIGN
0xA6 U+00A6 BROKEN BAR
0xA7 U+00A7 SECTION SIGN
0xA8 U+00A4 CURRENCY SIGN
0xA9 U+00A9 COPYRIGHT SIGN
0xAA U+00AA FEMININE ORDINAL INDICATOR
0xAB U+00AB LEFT-POINTING DOUBLE ANGLE QUOTATION MARK
0xAC U+00AC NOT SIGN
0xAD U+00AD SOFT HYPHEN
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+00BD VULGAR FRACTION ONE HALF
0xBE U+00BE VULGAR FRACTION THREE QUARTERS
0xBF U+00BF INVERTED QUESTION MARK
0xC0 U+00C0 LATIN CAPITAL LETTER A WITH GRAVE
0xC1 U+00C1 LATIN CAPITAL LETTER A WITH ACUTE
0xC2 U+00C2 LATIN CAPITAL LETTER A WITH CIRCUMFLEX
0xC3 U+00C3 LATIN CAPITAL LETTER A WITH TILDE
0xC4 U+00C4 LATIN CAPITAL LETTER A WITH DIAERESIS
0xC5 U+00C5 LATIN CAPITAL LETTER A WITH RING ABOVE
0xC6 U+00C6 LATIN CAPITAL LETTER AE
0xC7 U+00C7 LATIN CAPITAL LETTER C WITH CEDILLA
0xC8 U+00C8 LATIN CAPITAL LETTER E WITH GRAVE
0xC9 U+00C9 LATIN CAPITAL LETTER E WITH ACUTE
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+00F0 LATIN SMALL LETTER ETH
0xD1 U+00D1 LATIN CAPITAL LETTER N WITH TILDE
0xD2 U+00D2 LATIN CAPITAL LETTER O WITH GRAVE
0xD3 U+00D3 LATIN CAPITAL LETTER O WITH ACUTE
0xD4 U+00D4 LATIN CAPITAL LETTER O WITH CIRCUMFLEX
0xD5 U+00D5 LATIN CAPITAL LETTER O WITH TILDE
0xD6 U+00D6 LATIN CAPITAL LETTER O WITH DIAERESIS
0xD7 U+0152 LATIN CAPITAL LIGATURE OE
0xD8 U+00D8 LATIN CAPITAL LETTER O WITH STROKE
0xD9 U+00D9 LATIN CAPITAL LETTER U WITH GRAVE
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+00E0 LATIN SMALL LETTER A WITH GRAVE
0xE1 U+00E1 LATIN SMALL LETTER A WITH ACUTE
0xE2 U+00E2 LATIN SMALL LETTER A WITH CIRCUMFLEX
0xE3 U+00E3 LATIN SMALL LETTER A WITH TILDE
0xE4 U+00E4 LATIN SMALL LETTER A WITH DIAERESIS
0xE5 U+00E5 LATIN SMALL LETTER A WITH RING ABOVE
0xE6 U+00E6 LATIN SMALL LETTER AE
0xE7 U+00E7 LATIN SMALL LETTER C WITH CEDILLA
0xE8 U+00E8 LATIN SMALL LETTER E WITH GRAVE
0xE9 U+00E9 LATIN SMALL LETTER E WITH ACUTE
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+00D0 LATIN CAPITAL LETTER ETH
0xF1 U+00F1 LATIN SMALL LETTER N WITH TILDE
0xF2 U+00F2 LATIN SMALL LETTER O WITH GRAVE
0xF3 U+00F3 LATIN SMALL LETTER O WITH ACUTE
0xF4 U+00F4 LATIN SMALL LETTER O WITH CIRCUMFLEX
0xF5 U+00F5 LATIN SMALL LETTER O WITH TILDE
0xF6 U+00F6 LATIN SMALL LETTER O WITH DIAERESIS
0xF7 U+0153 LATIN SMALL LIGATURE OE
0xF8 U+00F8 LATIN SMALL LETTER O WITH STROKE
0xF9 U+00F9 LATIN SMALL LETTER U WITH GRAVE
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