Teradata Database uses the mapping in the following table for the following conversions:
UNICODE |
KanjiShiftJIS Single-Byte |
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+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+00A5 |
0x5C |
YEN SIGN |
U+203E |
0x7E |
OVERLINE |
U+FF61 |
0xA1 |
HALFWIDTH IDEOGRAPHIC FULL STOP |
U+FF62 |
0xA2 |
HALFWIDTH LEFT CORNER BRACKET |
U+FF63 |
0xA3 |
HALFWIDTH RIGHT CORNER BRACKET |
U+FF64 |
0xA4 |
HALFWIDTH IDEOGRAPHIC COMMA |
U+FF65 |
0xA5 |
HALFWIDTH KATAKANA MIDDLE DOT |
U+FF66 |
0xA6 |
HALFWIDTH KATAKANA LETTER WO |
U+FF67 |
0xA7 |
HALFWIDTH KATAKANA LETTER SMALL A |
U+FF68 |
0xA8 |
HALFWIDTH KATAKANA LETTER SMALL I |
U+FF69 |
0xA9 |
HALFWIDTH KATAKANA LETTER SMALL U |
U+FF6A |
0xAA |
HALFWIDTH KATAKANA LETTER SMALL E |
U+FF6B |
0xAB |
HALFWIDTH KATAKANA LETTER SMALL O |
U+FF6C |
0xAC |
HALFWIDTH KATAKANA LETTER SMALL YA |
U+FF6D |
0xAD |
HALFWIDTH KATAKANA LETTER SMALL YU |
U+FF6E |
0xAE |
HALFWIDTH KATAKANA LETTER SMALL YO |
U+FF6F |
0xAF |
HALFWIDTH KATAKANA LETTER SMALL TU |
U+FF70 |
0xB0 |
HALFWIDTH KATAKANA-HIRAGANA PROLONGED SOUND MARK |
U+FF71 |
0xB1 |
HALFWIDTH KATAKANA LETTER A |
U+FF72 |
0xB2 |
HALFWIDTH KATAKANA LETTER I |
U+FF73 |
0xB3 |
HALFWIDTH KATAKANA LETTER U |
U+FF74 |
0xB4 |
HALFWIDTH KATAKANA LETTER E |
U+FF75 |
0xB5 |
HALFWIDTH KATAKANA LETTER O |
U+FF76 |
0xB6 |
HALFWIDTH KATAKANA LETTER KA |
U+FF77 |
0xB7 |
HALFWIDTH KATAKANA LETTER KI |
U+FF78 |
0xB8 |
HALFWIDTH KATAKANA LETTER KU |
U+FF79 |
0xB9 |
HALFWIDTH KATAKANA LETTER KE |
U+FF7A |
0xBA |
HALFWIDTH KATAKANA LETTER KO |
U+FF7B |
0xBB |
HALFWIDTH KATAKANA LETTER SA |
U+FF7C |
0xBC |
HALFWIDTH KATAKANA LETTER SI |
U+FF7D |
0xBD |
HALFWIDTH KATAKANA LETTER SU |
U+FF7E |
0xBE |
HALFWIDTH KATAKANA LETTER SE |
U+FF7F |
0xBF |
HALFWIDTH KATAKANA LETTER SO |
U+FF80 |
0xC0 |
HALFWIDTH KATAKANA LETTER TA |
U+FF81 |
0xC1 |
HALFWIDTH KATAKANA LETTER TI |
U+FF82 |
0xC2 |
HALFWIDTH KATAKANA LETTER TU |
U+FF83 |
0xC3 |
HALFWIDTH KATAKANA LETTER TE |
U+FF84 |
0xC4 |
HALFWIDTH KATAKANA LETTER TO |
U+FF85 |
0xC5 |
HALFWIDTH KATAKANA LETTER NA |
U+FF86 |
0xC6 |
HALFWIDTH KATAKANA LETTER NI |
U+FF87 |
0xC7 |
HALFWIDTH KATAKANA LETTER NU |
U+FF88 |
0xC8 |
HALFWIDTH KATAKANA LETTER NE |
U+FF89 |
0xC9 |
HALFWIDTH KATAKANA LETTER NO |
U+FF8A |
0xCA |
HALFWIDTH KATAKANA LETTER HA |
U+FF8B |
0xCB |
HALFWIDTH KATAKANA LETTER HI |
U+FF8C |
0xCC |
HALFWIDTH KATAKANA LETTER HU |
U+FF8D |
0xCD |
HALFWIDTH KATAKANA LETTER HE |
U+FF8E |
0xCE |
HALFWIDTH KATAKANA LETTER HO |
U+FF8F |
0xCF |
HALFWIDTH KATAKANA LETTER MA |
U+FF90 |
0xD0 |
HALFWIDTH KATAKANA LETTER MI |
U+FF91 |
0xD1 |
HALFWIDTH KATAKANA LETTER MU |
U+FF92 |
0xD2 |
HALFWIDTH KATAKANA LETTER ME |
U+FF93 |
0xD3 |
HALFWIDTH KATAKANA LETTER MO |
U+FF94 |
0xD4 |
HALFWIDTH KATAKANA LETTER YA |
U+FF95 |
0xD5 |
HALFWIDTH KATAKANA LETTER YU |
U+FF96 |
0xD6 |
HALFWIDTH KATAKANA LETTER YO |
U+FF97 |
0xD7 |
HALFWIDTH KATAKANA LETTER RA |
U+FF98 |
0xD8 |
HALFWIDTH KATAKANA LETTER RI |
U+FF99 |
0xD9 |
HALFWIDTH KATAKANA LETTER RU |
U+FF9A |
0xDA |
HALFWIDTH KATAKANA LETTER RE |
U+FF9B |
0xDB |
HALFWIDTH KATAKANA LETTER RO |
U+FF9C |
0xDC |
HALFWIDTH KATAKANA LETTER WA |
U+FF9D |
0xDD |
HALFWIDTH KATAKANA LETTER N |
U+FF9E |
0xDE |
HALFWIDTH KATAKANA VOICED SOUND MARK |
U+FF9F |
0xDF |
HALFWIDTH KATAKANA SEMI-VOICED SOUND MARK |
U+FFFD |
0x1A |
REPLACEMENT CHARACTER & <control> |