Client KANJISJIS_0S Single-Byte to Server KANJI1 - 17.10 - Client KANJISJIS_0S Single-Byte to Server KANJI1 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

The following table shows how Teradata Database maps single-byte characters in the KANJISJIS_0S client character set (JIS-x0201) to the KANJI1 server character set.

KANJISJIS _0S Single-Byte KANJI1 Unicode Character Name
0x00 0x00 <control> NULL
0x01 0x01 <control> START OF HEADING
0x02 0x02 <control> START OF TEXT
0x03 0x03 <control> END OF TEXT
0x04 0x04 <control> END OF TRANSMISSION
0x05 0x05 <control> ENQUIRY
0x06 0x06 <control> ACKNOWLEDGE
0x07 0x07 <control> BELL
0x08 0x08 <control> BACKSPACE
0x09 0x09 <control> CHARACTER TABULATION (horizontal tabulation)
0x0A 0x0A <control> LINE FEED
0x0B 0x0B <control> LINE TABULATION (vertical tabulation)
0x0C 0x0C <control> FORM FEED
0x0D 0x0D <control> CARRIAGE RETURN
0x0E 0x0E <control> SHIFT OUT
0x0F 0x0F <control> SHIFT IN
0x10 0x10 <control> DATA LINK ESCAPE
0x11 0x11 <control> DEVICE CONTROL ONE
0x12 0x12 <control> DEVICE CONTROL TWO
0x13 0x13 <control> DEVICE CONTROL THREE
0x14 0x14 <control> DEVICE CONTROL FOUR
0x15 0x15 <control> NEGATIVE ACKNOWLEDGE
0x16 0x16 <control> SYNCHRONOUS IDLE
0x17 0x17 <control> END OF TRANSMISSION BLOCK
0x18 0x18 <control> CANCEL
0x19 0x19 <control> END OF MEDIUM
0x1A 0x1A <control> SUBSTITUTE
0x1B 0x1B <control> ESCAPE
0x1C 0x1C <control> INFORMATION SEPARATOR FOUR (file separator)
0x1D 0x1D <control> INFORMATION SEPARATOR THREE (group separator)
0x1E 0x1E <control> INFORMATION SEPARATOR TWO (record separator)
0x1F 0x1F <control> INFORMATION SEPARATOR ONE (unit separator)
0x20 0x20 SPACE
0x21 0x21 EXCLAMATION MARK
0x22 0x22 QUOTATION MARK
0x23 0x23 NUMBER SIGN
0x24 0x24 DOLLAR SIGN
0x25 0x25 PERCENT SIGN
0x26 0x26 AMPERSAND
0x27 0x27 APOSTROPHE
0x28 0x28 LEFT PARENTHESIS
0x29 0x29 RIGHT PARENTHESIS
0x2A 0x2A ASTERISK
0x2B 0x2B PLUS SIGN
0x2C 0x2C COMMA
0x2D 0x2D HYPHEN-MINUS
0x2E 0x2E FULL STOP
0x2F 0x2F SOLIDUS
0x30 0x30 DIGIT ZERO
0x31 0x31 DIGIT ONE
0x32 0x32 DIGIT TWO
0x33 0x33 DIGIT THREE
0x34 0x34 DIGIT FOUR
0x35 0x35 DIGIT FIVE
0x36 0x36 DIGIT SIX
0x37 0x37 DIGIT SEVEN
0x38 0x38 DIGIT EIGHT
0x39 0x39 DIGIT NINE
0x3A 0x3A COLON
0x3B 0x3B SEMICOLON
0x3C 0x3C LESS-THAN SIGN
0x3D 0x3D EQUALS SIGN
0x3E 0x3E GREATER-THAN SIGN
0x3F 0x3F QUESTION MARK
0x40 0x40 COMMERCIAL AT
0x41 0x41 LATIN CAPITAL LETTER A
0x42 0x42 LATIN CAPITAL LETTER B
0x43 0x43 LATIN CAPITAL LETTER C
0x44 0x44 LATIN CAPITAL LETTER D
0x45 0x45 LATIN CAPITAL LETTER E
0x46 0x46 LATIN CAPITAL LETTER F
0x47 0x47 LATIN CAPITAL LETTER G
0x48 0x48 LATIN CAPITAL LETTER H
0x49 0x49 LATIN CAPITAL LETTER I
0x4A 0x4A LATIN CAPITAL LETTER J
0x4B 0x4B LATIN CAPITAL LETTER K
0x4C 0x4C LATIN CAPITAL LETTER L
0x4D 0x4D LATIN CAPITAL LETTER M
0x4E 0x4E LATIN CAPITAL LETTER N
0x4F 0x4F LATIN CAPITAL LETTER O
0x50 0x50 LATIN CAPITAL LETTER P
0x51 0x51 LATIN CAPITAL LETTER Q
0x52 0x52 LATIN CAPITAL LETTER R
0x53 0x53 LATIN CAPITAL LETTER S
0x54 0x54 LATIN CAPITAL LETTER T
0x55 0x55 LATIN CAPITAL LETTER U
0x56 0x56 LATIN CAPITAL LETTER V
0x57 0x57 LATIN CAPITAL LETTER W
0x58 0x58 LATIN CAPITAL LETTER X
0x59 0x59 LATIN CAPITAL LETTER Y
0x5A 0x5A LATIN CAPITAL LETTER Z
0x5B 0x5B LEFT SQUARE BRACKET
0x5C 0x5C YEN SIGN
0x5D 0x5D RIGHT SQUARE BRACKET
0x5E 0x5E CIRCUMFLEX ACCENT
0x5F 0x5F LOW LINE
0x60 0x60 GRAVE ACCENT
0x61 0x61 LATIN SMALL LETTER A
0x62 0x62 LATIN SMALL LETTER B
0x63 0x63 LATIN SMALL LETTER C
0x64 0x64 LATIN SMALL LETTER D
0x65 0x65 LATIN SMALL LETTER E
0x66 0x66 LATIN SMALL LETTER F
0x67 0x67 LATIN SMALL LETTER G
0x68 0x68 LATIN SMALL LETTER H
0x69 0x69 LATIN SMALL LETTER I
0x6A 0x6A LATIN SMALL LETTER J
0x6B 0x6B LATIN SMALL LETTER K
0x6C 0x6C LATIN SMALL LETTER L
0x6D 0x6D LATIN SMALL LETTER M
0x6E 0x6E LATIN SMALL LETTER N
0x6F 0x6F LATIN SMALL LETTER O
0x70 0x70 LATIN SMALL LETTER P
0x71 0x71 LATIN SMALL LETTER Q
0x72 0x72 LATIN SMALL LETTER R
0x73 0x73 LATIN SMALL LETTER S
0x74 0x74 LATIN SMALL LETTER T
0x75 0x75 LATIN SMALL LETTER U
0x76 0x76 LATIN SMALL LETTER V
0x77 0x77 LATIN SMALL LETTER W
0x78 0x78 LATIN SMALL LETTER X
0x79 0x79 LATIN SMALL LETTER Y
0x7A 0x7A LATIN SMALL LETTER Z
0x7B 0x7B LEFT CURLY BRACKET
0x7C 0x7C VERTICAL LINE
0x7D 0x7D RIGHT CURLY BRACKET
0x7E 0x7E OVERLINE
0x7F 0x7F DELETE, RUBOUT
0xA1 0xA1 HALFWIDTH IDEOGRAPHIC FULL STOP
0xA2 0xA2 HALFWIDTH LEFT CORNER BRACKET
0xA3 0xA3 HALFWIDTH RIGHT CORNER BRACKET
0xA4 0xA4 HALFWIDTH IDEOGRAPHIC COMMA
0xA5 0xA5 HALFWIDTH KATAKANA MIDDLE DOT
0xA6 0xA6 HALFWIDTH KATAKANA LETTER WO
0xA7 0xA7 HALFWIDTH KATAKANA LETTER SMALL A
0xA8 0xA8 HALFWIDTH KATAKANA LETTER SMALL I
0xA9 0xA9 HALFWIDTH KATAKANA LETTER SMALL U
0xAA 0xAA HALFWIDTH KATAKANA LETTER SMALL E
0xAB 0xAB HALFWIDTH KATAKANA LETTER SMALL O
0xAC 0xAC HALFWIDTH KATAKANA LETTER SMALL YA
0xAD 0xAD HALFWIDTH KATAKANA LETTER SMALL YU
0xAE 0xAE HALFWIDTH KATAKANA LETTER SMALL YO
0xAF 0xAF HALFWIDTH KATAKANA LETTER SMALL TU
0xB0 0xB0 HALFWIDTH KATAKANA-HIRAGANA PROLONGED SOUND MARK
0xB1 0xB1 HALFWIDTH KATAKANA LETTER A
0xB2 0xB2 HALFWIDTH KATAKANA LETTER I
0xB3 0xB3 HALFWIDTH KATAKANA LETTER U
0xB4 0xB4 HALFWIDTH KATAKANA LETTER E
0xB5 0xB5 HALFWIDTH KATAKANA LETTER O
0xB6 0xB6 HALFWIDTH KATAKANA LETTER KA
0xB7 0xB7 HALFWIDTH KATAKANA LETTER KI
0xB8 0xB8 HALFWIDTH KATAKANA LETTER KU
0xB9 0xB9 HALFWIDTH KATAKANA LETTER KE
0xBA 0xBA HALFWIDTH KATAKANA LETTER KO
0xBB 0xBB HALFWIDTH KATAKANA LETTER SA
0xBC 0xBC HALFWIDTH KATAKANA LETTER SI
0xBD 0xBD HALFWIDTH KATAKANA LETTER SU
0xBE 0xBE HALFWIDTH KATAKANA LETTER SE
0xBF 0xBF HALFWIDTH KATAKANA LETTER SO
0xC0 0xC0 HALFWIDTH KATAKANA LETTER TA
0xC1 0xC1 HALFWIDTH KATAKANA LETTER TI
0xC2 0xC2 HALFWIDTH KATAKANA LETTER TU
0xC3 0xC3 HALFWIDTH KATAKANA LETTER TE
0xC4 0xC4 HALFWIDTH KATAKANA LETTER TO
0xC5 0xC5 HALFWIDTH KATAKANA LETTER NA
0xC6 0xC6 HALFWIDTH KATAKANA LETTER NI
0xC7 0xC7 HALFWIDTH KATAKANA LETTER NU
0xC8 0xC8 HALFWIDTH KATAKANA LETTER NE
0xC9 0xC9 HALFWIDTH KATAKANA LETTER NO
0xCA 0xCA HALFWIDTH KATAKANA LETTER HA
0xCB 0xCB HALFWIDTH KATAKANA LETTER HI
0xCC 0xCC HALFWIDTH KATAKANA LETTER HU
0xCD 0xCD HALFWIDTH KATAKANA LETTER HE
0xCE 0xCE HALFWIDTH KATAKANA LETTER HO
0xCF 0xCF HALFWIDTH KATAKANA LETTER MA
0xD0 0xD0 HALFWIDTH KATAKANA LETTER MI
0xD1 0xD1 HALFWIDTH KATAKANA LETTER MU
0xD2 0xD2 HALFWIDTH KATAKANA LETTER ME
0xD3 0xD3 HALFWIDTH KATAKANA LETTER MO
0xD4 0xD4 HALFWIDTH KATAKANA LETTER YA
0xD5 0xD5 HALFWIDTH KATAKANA LETTER YU
0xD6 0xD6 HALFWIDTH KATAKANA LETTER YO
0xD7 0xD7 HALFWIDTH KATAKANA LETTER RA
0xD8 0xD8 HALFWIDTH KATAKANA LETTER RI
0xD9 0xD9 HALFWIDTH KATAKANA LETTER RU
0xDA 0xDA HALFWIDTH KATAKANA LETTER RE
0xDB 0xDB HALFWIDTH KATAKANA LETTER RO
0xDC 0xDC HALFWIDTH KATAKANA LETTER WA
0xDD 0xDD HALFWIDTH KATAKANA LETTER N
0xDE 0xDE HALFWIDTH KATAKANA VOICED SOUND MARK
0xDF 0xDF HALFWIDTH KATAKANA SEMI-VOICED SOUND MARK