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:
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 |