16.20 - Non-GRAPHIC Characters - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K

The following table identifies non-GRAPHIC characters in the UNICODE server character set.

Teradata Database substitutes the GRAPHIC REPLACEMENT CHARACTER (0xFFFD) for non-GRAPHIC characters when you use the TRANSLATE function and specify the following:
  • WITH ERROR option
  • UNICODE_TO_GRAPHIC
Code Unicode Character Name Code Unicode Character Name
U+0000 <control> NULL U+0092 <control> PRIVATE USE TWO
U+0001 <control> START OF HEADING U+0093 <control> SET TRANSMIT RATE
U+0002 <control> START OF TEXT U+0094 <control> CANCEL CHARACTER
U+0003 <control> END OF TEXT U+0095 <control> MESSAGE WAITING
U+0004 <control> END OF TRANSMISSION U+0096 <control> START OF GUARDED AREA
U+0005 <control> ENQUIRY U+0097 <control> END OF GUARDED AREA
U+0006 <control> ACKNOWLEDGE U+0098 <control> START OF STRING
U+0007 <control> BELL U+0099 <control>
U+0008 <control> BACKSPACE U+009A <control> SINGLE CHARACTER INTRODUCER
U+0009 <control> CHARACTER TABULATION (horizontal tabulation) U+009B <control> CONTROL SEQUENCE INTRODUCER
U+000A <control> LINE FEED U+009C <control> STRING TERMINATOR
U+000B <control> LINE TABULATION (vertical tabulation) U+009D <control> OPERATING SYSTEM COMMAND
U+000C <control> FORM FEED U+009E <control> PRIVACY MESSAGE
U+000D <control> CARRIAGE RETURN U+009F <control> APPLICATION PROGRAM COMMAND
U+000E <control> SHIFT OUT U+00A2 CENT SIGN
U+000F <control> SHIFT IN U+00A3 POUND SIGN
U+0010 <control> DATA LINK ESCAPE U+00A5 YEN SIGN
U+0011 <control> DEVICE CONTROL ONE U+00A6 BROKEN BAR
U+0012 <control> DEVICE CONTRO TWO U+00AC NOT SIGN
U+0013 <control> DEVICE CONTROL THREE U+00AF MACRON
U+0014 <control> DEVICE CONTROL FOUR U+203E OVERLINE
U+0015 <control> NEGATIVE ACKNOWLEDGE U+20A9 WON SIGN
U+0016 <control> SYNCHRONOUS IDLE 0x2985 LEFT WHITE PARENTHESIS
U+0017 <control> END OF TRANSMISSION BLOCK 0x2986 RIGHT WHITE PARENTHESIS
U+0018 <control> CANCEL U+FF61 HALFWIDTH IDEOGRAPHIC FULL STOP
U+0019 <control> END OF MEDIUM U+FF62 HALFWIDTH LEFT CORNER BRACKET
U+001A <control> SUBSTITUTE U+FF63 HALFWIDTH RIGHT CORNER BRACKET
U+001B <control> ESCAPE U+FF64 HALFWIDTH IDEOGRAPHIC COMMA
U+001C <control> INFORMATION SEPARATOR FOUR (file separator) U+FF65 HALFWIDTH KATAKANA MIDDLE DOT
U+001D <control> INFORMATION SEPARATOR THREE (group separator) U+FF66 HALFWIDTH KATAKANA LETTER WO
U+001E <control> INFORMATION SEPARATOR TWO (record separator) U+FF67 HALFWIDTH KATAKANA LETTER SMALL A
U+001F <control> INFORMATION SEPARATOR ONE (unit separator) U+FF68 HALFWIDTH KATAKANA LETTER SMALL I
U+0020 SPACE U+FF69 HALFWIDTH KATAKANA LETTER SMALL U
U+0021 EXCLAMATION MARK U+FF6A HALFWIDTH KATAKANA LETTER SMALL E
U+0022 QUOTATION MARK U+FF6B HALFWIDTH KATAKANA LETTER SMALL O
U+0023 NUMBER SIGN U+FF6C HALFWIDTH KATAKANA LETTER SMALL YA
U+0024 DOLLAR SIGN U+FF6D HALFWIDTH KATAKANA LETTER SMALL YU
U+0025 PERCENT SIGN U+FF6E HALFWIDTH KATAKANA LETTER SMALL YO
U+0026 AMPERSAND U+FF6F HALFWIDTH KATAKANA LETTER SMALL TU
U+0027 APOSTROPHE U+FF70 HALFWIDTH KATAKANA-HIRAGANA PROLONGED SOUND MARK
U+0028 LEFT PARENTHESIS U+FF71 HALFWIDTH KATAKANA LETTER A
U+0029 RIGHT PARENTHESIS U+FF72 HALFWIDTH KATAKANA LETTER I
U+002A ASTERISK U+FF73 HALFWIDTH KATAKANA LETTER U
U+002B PLUS SIGN U+FF74 HALFWIDTH KATAKANA LETTER E
U+002C COMMA U+FF75 HALFWIDTH KATAKANA LETTER O
U+002D HYPHEN-MINUS U+FF76 HALFWIDTH KATAKANA LETTER KA
U+002E FULL STOP U+FF77 HALFWIDTH KATAKANA LETTER KI
U+002F SOLIDUS U+FF78 HALFWIDTH KATAKANA LETTER KU
U+0030 DIGIT ZERO U+FF79 HALFWIDTH KATAKANA LETTER KE
U+0031 DIGIT ONE U+FF7A HALFWIDTH KATAKANA LETTER KO
U+0032 DIGIT TWO U+FF7B HALFWIDTH KATAKANA LETTER SA
U+0033 DIGIT THREE U+FF7C HALFWIDTH KATAKANA LETTER SI
U+0034 DIGIT FOUR U+FF7D HALFWIDTH KATAKANA LETTER SU
U+0035 DIGIT FIVE U+FF7E HALFWIDTH KATAKANA LETTER SE
U+0036 DIGIT SIX U+FF7F HALFWIDTH KATAKANA LETTER SO
U+0037 DIGIT SEVEN U+FF80 HALFWIDTH KATAKANA LETTER TA
U+0038 DIGIT EIGHT U+FF81 HALFWIDTH KATAKANA LETTER TI
U+0039 DIGIT NINE U+FF82 HALFWIDTH KATAKANA LETTER TU
U+003A COLON U+FF83 HALFWIDTH KATAKANA LETTER TE
U+003B SEMICOLON U+FF84 HALFWIDTH KATAKANA LETTER TO
U+003C LESS-THAN SIGN U+FF85 HALFWIDTH KATAKANA LETTER NA
U+003D EQUALS SIGN U+FF86 HALFWIDTH KATAKANA LETTER NI
U+003E GREATER-THAN SIGN U+FF87 HALFWIDTH KATAKANA LETTER NU
U+003F QUESTION MARK U+FF88 HALFWIDTH KATAKANA LETTER NE
U+0040 COMMERCIAL AT U+FF89 HALFWIDTH KATAKANA LETTER NO
U+0041 LATIN CAPITAL LETTER A U+FF8A HALFWIDTH KATAKANA LETTER HA
U+0042 LATIN CAPITAL LETTER B U+FF8B HALFWIDTH KATAKANA LETTER HI
U+0043 LATIN CAPITAL LETTER C U+FF8C HALFWIDTH KATAKANA LETTER HU
U+0044 LATIN CAPITAL LETTER D U+FF8D HALFWIDTH KATAKANA LETTER HE
U+0045 LATIN CAPITAL LETTER E U+FF8E HALFWIDTH KATAKANA LETTER HO
U+0046 LATIN CAPITAL LETTER F U+FF8F HALFWIDTH KATAKANA LETTER MA
U+0047 LATIN CAPITAL LETTER G U+FF90 HALFWIDTH KATAKANA LETTER MI
U+0048 LATIN CAPITAL LETTER H U+FF91 HALFWIDTH KATAKANA LETTER MU
U+0049 LATIN CAPITAL LETTER I U+FF92 HALFWIDTH KATAKANA LETTER ME
U+004A LATIN CAPITAL LETTER J U+FF93 HALFWIDTH KATAKANA LETTER MO
U+004B LATIN CAPITAL LETTER K U+FF94 HALFWIDTH KATAKANA LETTER YA
U+004C LATIN CAPITAL LETTER L U+FF95 HALFWIDTH KATAKANA LETTER YU
U+004D LATIN CAPITAL LETTER M U+FF96 HALFWIDTH KATAKANA LETTER YO
U+004E LATIN CAPITAL LETTER N U+FF97 HALFWIDTH KATAKANA LETTER RA
U+004F LATIN CAPITAL LETTER O U+FF98 HALFWIDTH KATAKANA LETTER RI
U+0050 LATIN CAPITAL LETTER P U+FF99 HALFWIDTH KATAKANA LETTER RU
U+0051 LATIN CAPITAL LETTER Q U+FF9A HALFWIDTH KATAKANA LETTER RE
U+0052 LATIN CAPITAL LETTER R U+FF9B HALFWIDTH KATAKANA LETTER RO
U+0053 LATIN CAPITAL LETTER S U+FF9C HALFWIDTH KATAKANA LETTER WA
U+0054 LATIN CAPITAL LETTER T U+FF9D HALFWIDTH KATAKANA LETTER N
U+0055 LATIN CAPITAL LETTER U U+FF9E HALFWIDTH KATAKANA VOICED SOUND MARK
U+0056 LATIN CAPITAL LETTER V U+FF9F HALFWIDTH KATAKANA SEMI-VOICED SOUND MARK
U+0057 LATIN CAPITAL LETTER W U+FFA0 HALFWIDTH HANGUL FILLER
U+0058 LATIN CAPITAL LETTER X U+FFA1 HALFWIDTH HANGUL LETTER KIYEOK
U+0059 LATIN CAPITAL LETTER Y U+FFA2 HALFWIDTH HANGUL LETTER SSANGKIYEOK
U+005A LATIN CAPITAL LETTER Z U+FFA3 HALFWIDTH HANGUL LETTER KIYEOK-SIOS
U+005B LEFT SQUARE BRACKET U+FFA4 HALFWIDTH HANGUL LETTER NIEUN
U+005C REVERSE SOLIDUS U+FFA5 HALFWIDTH HANGUL LETTER NIEUN-CIEUC
U+005D RIGHT SQUARE BRACKET U+FFA6 HALFWIDTH HANGUL LETTER NIEUN-HIEUH
U+005E CIRCUMFLEX ACCENT U+FFA7 HALFWIDTH HANGUL LETTER TIKEUT
U+005F LOW LINE U+FFA8 HALFWIDTH HANGUL LETTER SSANGTIKEUT
U+0060 GRAVE ACCENT U+FFA9 HALFWIDTH HANGUL LETTER RIEUL
U+0061 LATIN SMALL LETTER A U+FFAA HALFWIDTH HANGUL LETTER RIEUL-KIYEOK
U+0062 LATIN SMALL LETTER B U+FFAB HALFWIDTH HANGUL LETTER RIEUL-MIEUM
U+0063 LATIN SMALL LETTER C U+FFAC HALFWIDTH HANGUL LETTER RIEUL-PIEUP
U+0064 LATIN SMALL LETTER D U+FFAD HALFWIDTH HANGUL LETTER RIEUL-SIOS
U+0065 LATIN SMALL LETTER E U+FFAE HALFWIDTH HANGUL LETTER RIEUL-THIEUTH
U+0066 LATIN SMALL LETTER F U+FFAF HALFWIDTH HANGUL LETTER RIEUL-PHIEUPH
U+0067 LATIN SMALL LETTER G U+FFB0 HALFWIDTH HANGUL LETTER RIEUL-HIEUH
U+0068 LATIN SMALL LETTER H U+FFB1 HALFWIDTH HANGUL LETTER MIEUM
U+0069 LATIN SMALL LETTER I U+FFB2 HALFWIDTH HANGUL LETTER PIEUP
U+006A LATIN SMALL LETTER J U+FFB3 HALFWIDTH HANGUL LETTER SSANGPIEUP
U+006B LATIN SMALL LETTER K U+FFB4 HALFWIDTH HANGUL LETTER PIEUP-SIOS
U+006C LATIN SMALL LETTER L U+FFB5 HALFWIDTH HANGUL LETTER SIOS
U+006D LATIN SMALL LETTER M U+FFB6 HALFWIDTH HANGUL LETTER SSANGSIOS
U+006E LATIN SMALL LETTER N U+FFB7 HALFWIDTH HANGUL LETTER IEUNG
U+006F LATIN SMALL LETTER O U+FFB8 HALFWIDTH HANGUL LETTER CIEUC
U+0070 LATIN SMALL LETTER P U+FFB9 HALFWIDTH HANGUL LETTER SSANGCIEUC
U+0071 LATIN SMALL LETTER Q U+FFBA HALFWIDTH HANGUL LETTER CHIEUCH
U+0072 LATIN SMALL LETTER R U+FFBB HALFWIDTH HANGUL LETTER KHIEUKH
U+0073 LATIN SMALL LETTER S U+FFBC HALFWIDTH HANGUL LETTER THIEUTH
U+0074 LATIN SMALL LETTER T U+FFBD HALFWIDTH HANGUL LETTER PHIEUPH
U+0075 LATIN SMALL LETTER U U+FFBE HALFWIDTH HANGUL LETTER HIEUH
U+0076 LATIN SMALL LETTER V U+FFC2 HALFWIDTH HANGUL LETTER A
U+0077 LATIN SMALL LETTER W U+FFC3 HALFWIDTH HANGUL LETTER AE
U+0078 LATIN SMALL LETTER X U+FFC4 HALFWIDTH HANGUL LETTER YA
U+0079 LATIN SMALL LETTER Y U+FFC5 HALFWIDTH HANGUL LETTER YAE
U+007A LATIN SMALL LETTER Z U+FFC6 HALFWIDTH HANGUL LETTER EO
U+007B LEFT CURLY BRACKET U+FFC7 HALFWIDTH HANGUL LETTER E
U+007C VERTICAL LINE U+FFCA HALFWIDTH HANGUL LETTER YEO
U+007D RIGHT CURLY BRACKET U+FFCB HALFWIDTH HANGUL LETTER YE
U+007E TILDE U+FFCC HALFWIDTH HANGUL LETTER O
U+007F <control> DELETE U+FFCD HALFWIDTH HANGUL LETTER WA
U+0080 <control> U+FFCE HALFWIDTH HANGUL LETTER WAE
U+0081 <control> U+FFCF HALFWIDTH HANGUL LETTER OE
U+0082 <control> BREAK PERMITTED HERE U+FFD2 HALFWIDTH HANGUL LETTER YO
U+0083 <control> NO BREAK HERE U+FFD3 HALFWIDTH HANGUL LETTER U
U+0084 <control> U+FFD4 HALFWIDTH HANGUL LETTER WEO
U+0085 <control> NEXT LINE (NEL) U+FFD5 HALFWIDTH HANGUL LETTER WE
U+0086 <control> START OF SELECTED AREA U+FFD6 HALFWIDTH HANGUL LETTER WI
U+0087 <control> END OF SELECTED AREA U+FFD7 HALFWIDTH HANGUL LETTER YU
U+0088 <control> CHARACTER TABULATION SET U+FFDA HALFWIDTH HANGUL LETTER EU
U+0089 <control> CHARACTER TABULATION WITH JUSTIFICATION U+FFDB HALFWIDTH HANGUL LETTER YI
U+008A <control> LINE TABULATION SET U+FFDC HALFWIDTH HANGUL LETTER I
U+008B <control> PARTIAL LINE FORWARD U+FFE8 HALFWIDTH FORMS LIGHT VERTICAL
U+008C <control> PARTIAL LINE BACKWARD U+FFE9 HALFWIDTH LEFTWARDS ARROW
U+008D <control> REVERSE LINE FEED U+FFEA HALFWIDTH UPWARDS ARROW
U+008E <control> SINGLE SHIFT TWO U+FFEB HALFWIDTH RIGHTWARDS ARROW
U+008F <control> SINGLE SHIFT THREE U+FFEC HALFWIDTH DOWNWARDS ARROW
U+0090 <control> DEVICE CONTROL STRING U+FFED HALFWIDTH BLACK SQUARE
U+0091 <control> PRIVATE USE ONE U+FFEE HALFWIDTH WHITE CIRCLE