Single-Byte KANJISJIS Upper to Lowercase | Teradata Vantage - Single-Byte KANJISJIS Lowercase to Uppercase - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
xnf1627504141606.ditamap
dita:ditavalPath
xnf1627504141606.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantageā„¢

This section maps the lowercase single-byte portion of the KANJISJIS server character set to its uppercase single-byte equivalent. Teradata Database uses this mapping when you use the UPPER function on character strings defined with the KANJISJIS server character set.

KANJISJIS Lowercase Input KANJISJIS Uppercase Output
Code Unicode Character Name Code Unicode 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