Non-GRAPHIC Characters | Teradata Vantage - Non-GRAPHIC Characters - 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ā„¢

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

Vantage 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