Multibyte KANJISJIS Upper to Lowercase | Teradata Vantage - 17.10 - Multibyte KANJISJIS Lowercase to 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)

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

KanjiSJIS Lowercase Input KanjiSJIS Uppercase Output
Code Unicode Character Name Code Unicode Character Name
0x8281 FULLWIDTH LATIN SMALL LETTER A 0x8260 FULLWIDTH LATIN CAPITAL LETTER A
0x8282 FULLWIDTH LATIN SMALL LETTER B 0x8261 FULLWIDTH LATIN CAPITAL LETTER B
0x8283 FULLWIDTH LATIN SMALL LETTER C 0x8262 FULLWIDTH LATIN CAPITAL LETTER C
0x8284 FULLWIDTH LATIN SMALL LETTER D 0x8263 FULLWIDTH LATIN CAPITAL LETTER D
0x8285 FULLWIDTH LATIN SMALL LETTER E 0x8264 FULLWIDTH LATIN CAPITAL LETTER E
0x8286 FULLWIDTH LATIN SMALL LETTER F 0x8265 FULLWIDTH LATIN CAPITAL LETTER F
0x8287 FULLWIDTH LATIN SMALL LETTER G 0x8266 FULLWIDTH LATIN CAPITAL LETTER G
0x8288 FULLWIDTH LATIN SMALL LETTER H 0x8267 FULLWIDTH LATIN CAPITAL LETTER H
0x8289 FULLWIDTH LATIN SMALL LETTER I 0x8268 FULLWIDTH LATIN CAPITAL LETTER I
0x828A FULLWIDTH LATIN SMALL LETTER J 0x8269 FULLWIDTH LATIN CAPITAL LETTER J
0x828B FULLWIDTH LATIN SMALL LETTER K 0x826A FULLWIDTH LATIN CAPITAL LETTER K
0x828C FULLWIDTH LATIN SMALL LETTER L 0x826B FULLWIDTH LATIN CAPITAL LETTER L
0x828D FULLWIDTH LATIN SMALL LETTER M 0x826C FULLWIDTH LATIN CAPITAL LETTER M
0x828E FULLWIDTH LATIN SMALL LETTER N 0x826D FULLWIDTH LATIN CAPITAL LETTER N
0x828F FULLWIDTH LATIN SMALL LETTER O 0x826E FULLWIDTH LATIN CAPITAL LETTER O
0x8290 FULLWIDTH LATIN SMALL LETTER P 0x826F FULLWIDTH LATIN CAPITAL LETTER P
0x8291 FULLWIDTH LATIN SMALL LETTER Q 0x8270 FULLWIDTH LATIN CAPITAL LETTER Q
0x8292 FULLWIDTH LATIN SMALL LETTER R 0x8271 FULLWIDTH LATIN CAPITAL LETTER R
0x8293 FULLWIDTH LATIN SMALL LETTER S 0x8272 FULLWIDTH LATIN CAPITAL LETTER S
0x8294 FULLWIDTH LATIN SMALL LETTER T 0x8273 FULLWIDTH LATIN CAPITAL LETTER T
0x8295 FULLWIDTH LATIN SMALL LETTER U 0x8274 FULLWIDTH LATIN CAPITAL LETTER U
0x8296 FULLWIDTH LATIN SMALL LETTER V 0x8275 FULLWIDTH LATIN CAPITAL LETTER V
0x8297 FULLWIDTH LATIN SMALL LETTER W 0x8276 FULLWIDTH LATIN CAPITAL LETTER W
0x8298 FULLWIDTH LATIN SMALL LETTER X 0x8277 FULLWIDTH LATIN CAPITAL LETTER X
0x8299 FULLWIDTH LATIN SMALL LETTER Y 0x8278 FULLWIDTH LATIN CAPITAL LETTER Y
0x829A FULLWIDTH LATIN SMALL LETTER Z 0x8279 FULLWIDTH LATIN CAPITAL LETTER Z
0x83BF GREEK SMALL LETTER ALPHA 0x839F GREEK CAPITAL LETTER ALPHA
0x83C0 GREEK SMALL LETTER BETA 0x83A0 GREEK CAPITAL LETTER BETA
0x83C1 GREEK SMALL LETTER GAMMA 0x83A1 GREEK CAPITAL LETTER GAMMA
0x83C2 GREEK SMALL LETTER DELTA 0x83A2 GREEK CAPITAL LETTER DELTA
0x83C3 GREEK SMALL LETTER EPSILON 0x83A3 GREEK CAPITAL LETTER EPSILON
0x83C4 GREEK SMALL LETTER ZETA 0x83A4 GREEK CAPITAL LETTER ZETA
0x83C5 GREEK SMALL LETTER ETA 0x83A5 GREEK CAPITAL LETTER ETA
0x83C6 GREEK SMALL LETTER THETA 0x83A6 GREEK CAPITAL LETTER THETA
0x83C7 GREEK SMALL LETTER IOTA 0x83A7 GREEK CAPITAL LETTER IOTA
0x83C8 GREEK SMALL LETTER KAPPA 0x83A8 GREEK CAPITAL LETTER KAPPA
0x83C9 GREEK SMALL LETTER LAMDA 0x83A9 GREEK CAPITAL LETTER LAMDA
0x83CA GREEK SMALL LETTER MU 0x83AA GREEK CAPITAL LETTER MU
0x83CB GREEK SMALL LETTER NU 0x83AB GREEK CAPITAL LETTER NU
0x83CC GREEK SMALL LETTER XI 0x83AC GREEK CAPITAL LETTER XI
0x83CD GREEK SMALL LETTER OMICRON 0x83AD GREEK CAPITAL LETTER OMICRON
0x83CE GREEK SMALL LETTER PI 0x83AE GREEK CAPITAL LETTER PI
0x83CF GREEK SMALL LETTER RHO 0x83AF GREEK CAPITAL LETTER RHO
0x83D0 GREEK SMALL LETTER SIGMA 0x83B0 GREEK CAPITAL LETTER SIGMA
0x83D1 GREEK SMALL LETTER TAU 0x83B1 GREEK CAPITAL LETTER TAU
0x83D2 GREEK SMALL LETTER UPSILON 0x83B2 GREEK CAPITAL LETTER UPSILON
0x83D3 GREEK SMALL LETTER PHI 0x83B3 GREEK CAPITAL LETTER PHI
0x83D4 GREEK SMALL LETTER CHI 0x83B4 GREEK CAPITAL LETTER CHI
0x83D5 GREEK SMALL LETTER PSI 0x83B5 GREEK CAPITAL LETTER PSI
0x83D6 GREEK SMALL LETTER OMEGA 0x83B6 GREEK CAPITAL LETTER OMEGA
0x8470 CYRILLIC SMALL LETTER A 0x8440 CYRILLIC CAPITAL LETTER A
0x8471 CYRILLIC SMALL LETTER BE 0x8441 CYRILLIC CAPITAL LETTER BE
0x8472 CYRILLIC SMALL LETTER VE 0x8442 CYRILLIC CAPITAL LETTER VE
0x8473 CYRILLIC SMALL LETTER GHE 0x8443 CYRILLIC CAPITAL LETTER GHE
0x8474 CYRILLIC SMALL LETTER DE 0x8444 CYRILLIC CAPITAL LETTER DE
0x8475 CYRILLIC SMALL LETTER IE 0x8445 CYRILLIC CAPITAL LETTER IE
0x8476 CYRILLIC SMALL LETTER IO 0x8446 CYRILLIC CAPITAL LETTER IO
0x8477 CYRILLIC SMALL LETTER ZHE 0x8447 CYRILLIC CAPITAL LETTER ZHE
0x8478 CYRILLIC SMALL LETTER ZE 0x8448 CYRILLIC CAPITAL LETTER ZE
0x8479 CYRILLIC SMALL LETTER I 0x8449 CYRILLIC CAPITAL LETTER I
0x847A CYRILLIC SMALL LETTER 
SHORT I 0x844A CYRILLIC CAPITAL LETTER SHORT I
0x847B CYRILLIC SMALL LETTER KA 0x844B CYRILLIC CAPITAL LETTER KA
0x847C CYRILLIC SMALL LETTER EL 0x844C CYRILLIC CAPITAL LETTER EL
0x847D CYRILLIC SMALL LETTER EM 0x844D CYRILLIC CAPITAL LETTER EM
0x847E CYRILLIC SMALL LETTER EN 0x844E CYRILLIC CAPITAL LETTER EN
0x8480 CYRILLIC SMALL LETTER O 0x844F CYRILLIC CAPITAL LETTER O
0x8481 CYRILLIC SMALL LETTER PE 0x8450 CYRILLIC CAPITAL LETTER PE
0x8482 CYRILLIC SMALL LETTER ER 0x8451 CYRILLIC CAPITAL LETTER ER
0x8483 CYRILLIC SMALL LETTER ES 0x8452 CYRILLIC CAPITAL LETTER ES
0x8484 CYRILLIC SMALL LETTER TE 0x8453 CYRILLIC CAPITAL LETTER TE
0x8485 CYRILLIC SMALL LETTER U 0x8454 CYRILLIC CAPITAL LETTER U
0x8486 CYRILLIC SMALL LETTER EF 0x8455 CYRILLIC CAPITAL LETTER EF
0x8487 CYRILLIC SMALL LETTER HA 0x8456 CYRILLIC CAPITAL LETTER HA
0x8488 CYRILLIC SMALL LETTER TSE 0x8457 CYRILLIC CAPITAL LETTER TSE
0x8489 CYRILLIC SMALL LETTER CHE 0x8458 CYRILLIC CAPITAL LETTER CHE
0x848A CYRILLIC SMALL LETTER SHA 0x8459 CYRILLIC CAPITAL LETTER SHA
0x848B CYRILLIC SMALL LETTER SHCHA 0x845A CYRILLIC CAPITAL LETTER SHCHA
0x848C CYRILLIC SMALL LETTER HARD SIGN 0x845B CYRILLIC CAPITAL LETTER HARD SIGN
0x848D CYRILLIC SMALL LETTER YERU 0x845C CYRILLIC CAPITAL LETTER YERU
0x848E CYRILLIC SMALL LETTER SOFT SIGN 0x845D CYRILLIC CAPITAL LETTER SOFT SIGN
0x848F CYRILLIC SMALL LETTER E 0x845E CYRILLIC CAPITAL LETTER E
0x8490 CYRILLIC SMALL LETTER YU 0x845F CYRILLIC CAPITAL LETTER YU
0x8491 CYRILLIC SMALL LETTER YA 0x8460 CYRILLIC CAPITAL LETTER YA