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

ASCII LATIN Unicode Character Name
0x00 0x00 <control> NULL
0x01 0x01 <control> START OF HEADING
0x02 0x02 <control> START OF TEXT
0x03 0x03 <control> END OF TEXT
0x04 0x04 <control> END OF TRANSMISSION
0x05 0x05 <control> ENQUIRY
0x06 0x06 <control> ACKNOWLEDGE
0x07 0x07 <control> BELL
0x08 0x08 <control> BACKSPACE
0x09 0x09 <control> CHARACTER TABULATION (horizontal tabulation)
0x0A 0x0A <control> LINE FEED
0x0B 0x0B <control> LINE TABULATION (vertical tabulation)
0x0C 0x0C <control> FORM FEED
0x0D 0x0D <control> CARRIAGE RETURN
0x0E 0x0E <control> SHIFT OUT
0x0F 0x0F <control> SHIFT IN
0x10 0x10 <control> DATA LINK ESCAPE
0x11 0x11 <control> DEVICE CONTROL ONE
0x12 0x12 <control> DEVICE CONTROL TWO
0x13 0x13 <control> DEVICE CONTROL THREE
0x14 0x14 <control> DEVICE CONTROL FOUR
0x15 0x15 <control> NEGATIVE ACKNOWLEDGE
0x16 0x16 <control> SYNCHRONOUS IDLE
0x17 0x17 <control> END OF TRANSMISSION BLOCK
0x18 0x18 <control> CANCEL
0x19 0x19 <control> END OF MEDIUM
0x1A 0x1A <control> SUBSTITUTE
0x1B 0x1B <control> ESCAPE
0x1C 0x1C <control> INFORMATION SEPARATOR FOUR (file separator)
0x1D 0x1D <control> INFORMATION SEPARATOR THREE (group separator)
0x1E 0x1E <control> INFORMATION SEPARATOR TWO (record separator)
0x1F 0x1F <control> INFORMATION SEPARATOR ONE (unit separator)
0x20 0x20 SPACE
0x21 0x21 EXCLAMATION MARK
0x22 0x22 QUOTATION MARK
0x23 0x23 NUMBER SIGN
0x24 0x24 DOLLAR SIGN
0x25 0x25 PERCENT SIGN
0x26 0x26 AMPERSAND
0x27 0x27 APOSTROPHE
0x28 0x28 LEFT PARENTHESIS
0x29 0x29 RIGHT PARENTHESIS
0x2A 0x2A ASTERISK
0x2B 0x2B PLUS SIGN
0x2C 0x2C COMMA
0x2D 0x2D HYPHEN-MINUS
0x2E 0x2E FULL STOP
0x2F 0x2F SOLIDUS
0x30 0x30 DIGIT ZERO
0x31 0x31 DIGIT ONE
0x32 0x32 DIGIT TWO
0x33 0x33 DIGIT THREE
0x34 0x34 DIGIT FOUR
0x35 0x35 DIGIT FIVE
0x36 0x36 DIGIT SIX
0x37 0x37 DIGIT SEVEN
0x38 0x38 DIGIT EIGHT
0x39 0x39 DIGIT NINE
0x3A 0x3A COLON
0x3B 0x3B SEMICOLON
0x3C 0x3C LESS-THAN SIGN
0x3D 0x3D EQUALS SIGN
0x3E 0x3E GREATER-THAN SIGN
0x3F 0x3F QUESTION MARK
0x40 0x40 COMMERCIAL AT
0x41 0x41 LATIN CAPITAL LETTER A
0x42 0x42 LATIN CAPITAL LETTER B
0x43 0x43 LATIN CAPITAL LETTER C
0x44 0x44 LATIN CAPITAL LETTER D
0x45 0x45 LATIN CAPITAL LETTER E
0x46 0x46 LATIN CAPITAL LETTER F
0x47 0x47 LATIN CAPITAL LETTER G
0x48 0x48 LATIN CAPITAL LETTER H
0x49 0x49 LATIN CAPITAL LETTER I
0x4A 0x4A LATIN CAPITAL LETTER J
0x4B 0x4B LATIN CAPITAL LETTER K
0x4C 0x4C LATIN CAPITAL LETTER L
0x4D 0x4D LATIN CAPITAL LETTER M
0x4E 0x4E LATIN CAPITAL LETTER N
0x4F 0x4F LATIN CAPITAL LETTER O
0x50 0x50 LATIN CAPITAL LETTER P
0x51 0x51 LATIN CAPITAL LETTER Q
0x52 0x52 LATIN CAPITAL LETTER R
0x53 0x53 LATIN CAPITAL LETTER S
0x54 0x54 LATIN CAPITAL LETTER T
0x55 0x55 LATIN CAPITAL LETTER U
0x56 0x56 LATIN CAPITAL LETTER V
0x57 0x57 LATIN CAPITAL LETTER W
0x58 0x58 LATIN CAPITAL LETTER X
0x59 0x59 LATIN CAPITAL LETTER Y
0x5A 0x5A LATIN CAPITAL LETTER Z
0x5B 0x5B LEFT SQUARE BRACKET
0x5C 0x5C REVERSE SOLIDUS
0x5D 0x5D RIGHT SQUARE BRACKET
0x5E 0x5E CIRCUMFLEX ACCENT
0x5F 0x5F LOW LINE
0x60 0x60 GRAVE ACCENT
0x61 0x61 LATIN SMALL LETTER A
0x62 0x62 LATIN SMALL LETTER B
0x63 0x63 LATIN SMALL LETTER C
0x64 0x64 LATIN SMALL LETTER D
0x65 0x65 LATIN SMALL LETTER E
0x66 0x66 LATIN SMALL LETTER F
0x67 0x67 LATIN SMALL LETTER G
0x68 0x68 LATIN SMALL LETTER H
0x69 0x69 LATIN SMALL LETTER I
0x6A 0x6A LATIN SMALL LETTER J
0x6B 0x6B LATIN SMALL LETTER K
0x6C 0x6C LATIN SMALL LETTER L
0x6D 0x6D LATIN SMALL LETTER M
0x6E 0x6E LATIN SMALL LETTER N
0x6F 0x6F LATIN SMALL LETTER O
0x70 0x70 LATIN SMALL LETTER P
0x71 0x71 LATIN SMALL LETTER Q
0x72 0x72 LATIN SMALL LETTER R
0x73 0x73 LATIN SMALL LETTER S
0x74 0x74 LATIN SMALL LETTER T
0x75 0x75 LATIN SMALL LETTER U
0x76 0x76 LATIN SMALL LETTER V
0x77 0x77 LATIN SMALL LETTER W
0x78 0x78 LATIN SMALL LETTER X
0x79 0x79 LATIN SMALL LETTER Y
0x7A 0x7A LATIN SMALL LETTER Z
0x7B 0x7B LEFT CURLY BRACKET
0x7C 0x7C VERTICAL LINE
0x7D 0x7D RIGHT CURLY BRACKET
0x7E 0x7E TILDE
0x7F 0x7F <control> DELETE
0x80 0x80 NO-BREAK SPACE
0x81 0x81 DIAERESIS
0x82 0x82 ACUTE ACCENT
0x83 0x83 CEDILLA
0x84 0x84 MULTIPLICATION SIGN
0x85 0x85 DIVISION SIGN
0x86 0x86 <control> START OF SELECTED AREA
0x87 0x87 <control> END OF SELECTED AREA
0x88 0x88 <control> CHARACTER TABULATION SET
0x89 0x89 <control> CHARACTER TABULATION WITH JUSTIFICATION
0x8A 0x8A <control> LINE TABULATION SET
0x8B 0x8B <control> PARTIAL LINE FORWARD
0x8C 0x8C <control> PARTIAL LINE BACKWARD
0x8D 0x8D <control> REVERSE LINE FEED
0x8E 0x8E <control> SINGLE SHIFT TWO
0x8F 0x8F <control> SINGLE SHIFT THREE
0x90 0x90 <control> DEVICE CONTROL STRING
0x91 0x91 <control> PRIVATE USE ONE
0x92 0x92 <control> PRIVATE USE TWO
0x93 0x93 <control> SET TRANSMIT STATE
0x94 0x94 <control> CANCEL CHARACTER
0x95 0x95 <control> MESSAGE WAITING
0x96 0x96 <control> START OF GUARDED AREA
0x97 0x97 <control> END OF GUARDED AREA
0x98 0x98 <control> START OF STRING
0x99 0x99 <control>
0x9A 0x9A <control> SINGLE CHARACTER INTRODUCER
0x9B 0x9B <control> CONTROL SEQUENCE INTRODUCER
0x9C 0x9C <control> STRING TERMINATOR
0x9D 0x9D <control> OPERATING SYSTEM COMMAND
0x9E 0x9E <control> PRIVACY MESSAGE
0x9F 0x9F <control> APPLICATION PROGRAM COMMAND
0xA0 0xA0 LATIN SMALL LETTER S WITH CARON
0xA1 0xA1 INVERTED EXCLAMATION MARK
0xA2 0xA2 CENT SIGN
0xA3 0xA3 POUND SIGN
0xA4 0xA4 LATIN SMALL LETTER Y WITH ACUTE
0xA5 0xA5 YEN SIGN
0xA6 0xA6 BROKEN BAR
0xA7 0xA7 SECTION SIGN
0xA8 0xA8 CURRENCY SIGN
0xA9 0xA9 COPYRIGHT SIGN
0xAA 0xAA FEMININE ORDINAL INDICATOR
0xAB 0xAB LEFT-POINTING DOUBLE ANGLE QUOTATION MARK
0xAC 0xAC NOT SIGN
0xAD 0xAD SOFT HYPHEN
0xAE 0xAE REGISTERED SIGN
0xAF 0xAF MACRON
0xB0 0xB0 DEGREE SIGN
0xB1 0xB1 PLUS-MINUS SIGN
0xB2 0xB2 SUPERSCRIPT TWO
0xB3 0xB3 SUPERSCRIPT THREE
0xB4 0xB4 LATIN CAPITAL LETTER Y WITH ACUTE
0xB5 0xB5 MICRO SIGN
0xB6 0xB6 PILCROW SIGN
0xB7 0xB7 MIDDLE DOT
0xB8 0xB8 LATIN CAPITAL LETTER S WITH CARON
0xB9 0xB9 SUPERSCRIPT ONE
0xBA 0xBA MASCULINE ORDINAL INDICATOR
0xBB 0xBB RIGHT-POINTING DOUBLE ANGLE QUOTATION MARK
0xBC 0xBC VULGAR FRACTION ONE QUARTER
0xBD 0xBD VULGAR FRACTION ONE HALF
0xBE 0xBE VULGAR FRACTION THREE QUARTERS
0xBF 0xBF INVERTED QUESTION MARK
0xC0 0xC0 LATIN CAPITAL LETTER A WITH GRAVE
0xC1 0xC1 LATIN CAPITAL LETTER A WITH ACUTE
0xC2 0xC2 LATIN CAPITAL LETTER A WITH CIRCUMFLEX
0xC3 0xC3 LATIN CAPITAL LETTER A WITH TILDE
0xC4 0xC4 LATIN CAPITAL LETTER A WITH DIAERESIS
0xC5 0xC5 LATIN CAPITAL LETTER A WITH RING ABOVE
0xC6 0xC6 LATIN CAPITAL LETTER AE
0xC7 0xC7 LATIN CAPITAL LETTER C WITH CEDILLA
0xC8 0xC8 LATIN CAPITAL LETTER E WITH GRAVE
0xC9 0xC9 LATIN CAPITAL LETTER E WITH ACUTE
0xCA 0xCA LATIN CAPITAL LETTER E WITH CIRCUMFLEX
0xCB 0xCB LATIN CAPITAL LETTER E WITH DIAERESIS
0xCC 0xCC LATIN CAPITAL LETTER I WITH GRAVE
0xCD 0xCD LATIN CAPITAL LETTER I WITH ACUTE
0xCE 0xCE LATIN CAPITAL LETTER I WITH CIRCUMFLEX
0xCF 0xCF LATIN CAPITAL LETTER I WITH DIAERESIS
0xD0 0xD0 LATIN SMALL LETTER ETH
0xD1 0xD1 LATIN CAPITAL LETTER N WITH TILDE
0xD2 0xD2 LATIN CAPITAL LETTER O WITH GRAVE
0xD3 0xD3 LATIN CAPITAL LETTER O WITH ACUTE
0xD4 0xD4 LATIN CAPITAL LETTER O WITH CIRCUMFLEX
0xD5 0xD5 LATIN CAPITAL LETTER O WITH TILDE
0xD6 0xD6 LATIN CAPITAL LETTER O WITH DIAERESIS
0xD7 0xD7 LATIN CAPITAL LIGATURE OE
0xD8 0xD8 LATIN CAPITAL LETTER O WITH STROKE
0xD9 0xD9 LATIN CAPITAL LETTER U WITH GRAVE
0xDA 0xDA LATIN CAPITAL LETTER U WITH ACUTE
0xDB 0xDB LATIN CAPITAL LETTER U WITH CIRCUMFLEX
0xDC 0xDC LATIN CAPITAL LETTER U WITH DIAERESIS
0xDD 0xDD LATIN CAPITAL LETTER Y WITH DIAERESIS
0xDE 0xDE LATIN SMALL LETTER THORN
0xDF 0xDF LATIN SMALL LETTER SHARP S
0xE0 0xE0 LATIN SMALL LETTER A WITH GRAVE
0xE1 0xE1 LATIN SMALL LETTER A WITH ACUTE
0xE2 0xE2 LATIN SMALL LETTER A WITH CIRCUMFLEX
0xE3 0xE3 LATIN SMALL LETTER A WITH TILDE
0xE4 0xE4 LATIN SMALL LETTER A WITH DIAERESIS
0xE5 0xE5 LATIN SMALL LETTER A WITH RING ABOVE
0xE6 0xE6 LATIN SMALL LETTER AE
0xE7 0xE7 LATIN SMALL LETTER C WITH CEDILLA
0xE8 0xE8 LATIN SMALL LETTER E WITH GRAVE
0xE9 0xE9 LATIN SMALL LETTER E WITH ACUTE
0xEA 0xEA LATIN SMALL LETTER E WITH CIRCUMFLEX
0xEB 0xEB LATIN SMALL LETTER E WITH DIAERESIS
0xEC 0xEC LATIN SMALL LETTER I WITH GRAVE
0xED 0xED LATIN SMALL LETTER I WITH ACUTE
0xEE 0xEE LATIN SMALL LETTER I WITH CIRCUMFLEX
0xEF 0xEF LATIN SMALL LETTER I WITH DIAERESIS
0xF0 0xF0 LATIN CAPITAL LETTER ETH
0xF1 0xF1 LATIN SMALL LETTER N WITH TILDE
0xF2 0xF2 LATIN SMALL LETTER O WITH GRAVE
0xF3 0xF3 LATIN SMALL LETTER O WITH ACUTE
0xF4 0xF4 LATIN SMALL LETTER O WITH CIRCUMFLEX
0xF5 0xF5 LATIN SMALL LETTER O WITH TILDE
0xF6 0xF6 LATIN SMALL LETTER O WITH DIAERESIS
0xF7 0xF7 LATIN SMALL LIGATURE OE
0xF8 0xF8 LATIN SMALL LETTER O WITH STROKE
0xF9 0xF9 LATIN SMALL LETTER U WITH GRAVE
0xFA 0xFA LATIN SMALL LETTER U WITH ACUTE
0xFB 0xFB LATIN SMALL LETTER U WITH CIRCUMFLEX
0xFC 0xFC LATIN SMALL LETTER U WITH DIAERESIS
0xFD 0xFD LATIN SMALL LETTER Y WITH DIAERESIS
0xFE 0xFE LATIN CAPITAL LETTER THORN
0xFF 0xFF EURO SIGN