UNICODE to LATIN | Teradata Vantage - UNICODE to LATIN - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ywb1588027283948.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantageā„¢

This section maps UNICODE characters to their LATIN equivalents. Teradata Database uses this mapping when you translate a UNICODE string using the TRANSLATE function and specify UNICODE_TO_LATIN.

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