KANJISJIS_0S Single-Byte Lowercase to KANJI1 Uppercase - 17.10 - Client KANJISJIS_0S Single-Byte Lowercase to Server KANJI1 Uppercase - 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 the mapping of single-byte characters in the KANJISJIS_0S client character set to KANJI1 uppercase characters. An example of when Teradata Database uses this mapping is when the client character set is KANJISJIS_0S and single-byte character data is imported from the client to a character column that is CHARACTER SET KANJI1 UPPERCASE.

KANJISJIS_0S Single-Byte Lowercase KANJI1 Uppercase
Code Character Name Code Character Name
0x61 LATIN SMALL LETTER A 0x41 LATIN CAPITAL LETTER A
0x62 LATIN SMALL LETTER B 0x42 LATIN CAPITAL LETTER B
0x63 LATIN SMALL LETTER C 0x43 LATIN CAPITAL LETTER C
0x64 LATIN SMALL LETTER D 0x44 LATIN CAPITAL LETTER D
0x65 LATIN SMALL LETTER E 0x45 LATIN CAPITAL LETTER E
0x66 LATIN SMALL LETTER F 0x46 LATIN CAPITAL LETTER F
0x67 LATIN SMALL LETTER G 0x47 LATIN CAPITAL LETTER G
0x68 LATIN SMALL LETTER H 0x48 LATIN CAPITAL LETTER H
0x69 LATIN SMALL LETTER I 0x49 LATIN CAPITAL LETTER I
0x6A LATIN SMALL LETTER J 0x4A LATIN CAPITAL LETTER J
0x6B LATIN SMALL LETTER K 0x4B LATIN CAPITAL LETTER K
0x6C LATIN SMALL LETTER L 0x4C LATIN CAPITAL LETTER L
0x6D LATIN SMALL LETTER M 0x4D LATIN CAPITAL LETTER M
0x6E LATIN SMALL LETTER N 0x4E LATIN CAPITAL LETTER N
0x6F LATIN SMALL LETTER O 0x4F LATIN CAPITAL LETTER O
0x70 LATIN SMALL LETTER P 0x50 LATIN CAPITAL LETTER P
0x71 LATIN SMALL LETTER Q 0x51 LATIN CAPITAL LETTER Q
0x72 LATIN SMALL LETTER R 0x52 LATIN CAPITAL LETTER R
0x73 LATIN SMALL LETTER S 0x53 LATIN CAPITAL LETTER S
0x74 LATIN SMALL LETTER T 0x54 LATIN CAPITAL LETTER T
0x75 LATIN SMALL LETTER U 0x55 LATIN CAPITAL LETTER U
0x76 LATIN SMALL LETTER V 0x56 LATIN CAPITAL LETTER V
0x77 LATIN SMALL LETTER W 0x57 LATIN CAPITAL LETTER W
0x78 LATIN SMALL LETTER X 0x58 LATIN CAPITAL LETTER X
0x79 LATIN SMALL LETTER Y 0x59 LATIN CAPITAL LETTER Y
0x7A LATIN SMALL LETTER Z 0x5A LATIN CAPITAL LETTER Z