UNICODE to LATIN | Teradata Vantage - UNICODE to LATIN - Analytics Database - Teradata Vantage

International Character Set Support
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-09-27
dita:mapPath
aju1628095815656.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hqj1472245413611
lifecycle
latest
Product Category
Teradata Vantage™

This section maps UNICODE characters to their LATIN equivalents. Vantage 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>