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 |