16.10 - LATIN Uppercase to Lowercase - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

This section maps uppercase LATIN characters to the lowercase LATIN equivalents. Teradata Database uses this mapping when you use the LOWER function on LATIN character strings.

LATIN Uppercase Input LATIN Lowercase Output
Code Unicode Character Name Code Unicode Character Name
0x41 LATIN CAPITAL LETTER A 0x6 LATIN SMALL LETTER A
0x42 LATIN CAPITAL LETTER B 0x6 LATIN SMALL LETTER B
0x43 LATIN CAPITAL LETTER C 0x6 LATIN SMALL LETTER C
0x44 LATIN CAPITAL LETTER D 0x6 LATIN SMALL LETTER D
0x45 LATIN CAPITAL LETTER E 0x65 LATIN SMALL LETTER E
0x46 LATIN CAPITAL LETTER F 0x66 LATIN SMALL LETTER F
0x47 LATIN CAPITAL LETTER G 0x67 LATIN SMALL LETTER G
0x48 LATIN CAPITAL LETTER H 0x68 LATIN SMALL LETTER H
0x49 LATIN CAPITAL LETTER I 0x69 LATIN SMALL LETTER I
0x4A LATIN CAPITAL LETTER J 0x6A LATIN SMALL LETTER J
0x4B LATIN CAPITAL LETTER K 0x6B LATIN SMALL LETTER K
0x4C LATIN CAPITAL LETTER L 0x6C LATIN SMALL LETTER L
0x4D LATIN CAPITAL LETTER M 0x6D LATIN SMALL LETTER M
0x4E LATIN CAPITAL LETTER N 0x6E LATIN SMALL LETTER N
0x4F LATIN CAPITAL LETTER O 0x6F LATIN SMALL LETTER O
0x50 LATIN CAPITAL LETTER P 0x70 LATIN SMALL LETTER P
0x51 LATIN CAPITAL LETTER Q 0x71 LATIN SMALL LETTER Q
0x52 LATIN CAPITAL LETTER R 0x72 LATIN SMALL LETTER R
0x53 LATIN CAPITAL LETTER S 0x73 LATIN SMALL LETTER S
0x54 LATIN CAPITAL LETTER T 0x74 LATIN SMALL LETTER T
0x55 LATIN CAPITAL LETTER U 0x75 LATIN SMALL LETTER U
0x56 LATIN CAPITAL LETTER V 0x76 LATIN SMALL LETTER V
0x57 LATIN CAPITAL LETTER W 0x77 LATIN SMALL LETTER W
0x58 LATIN CAPITAL LETTER X 0x78 LATIN SMALL LETTER X
0x59 LATIN CAPITAL LETTER Y 0x79 LATIN SMALL LETTER Y
0x5A LATIN CAPITAL LETTER Z 0x7A LATIN SMALL LETTER Z
0xB8 LATIN CAPITAL LETTER S WITH CARON 0xA0 LATIN SMALL LETTER S WITH CARON
0xB4 LATIN CAPITAL LETTER Y WITH ACUTE 0xA4 LATIN SMALL LETTER Y WITH ACUTE
0xC0 LATIN CAPITAL LETTER A WITH GRAVE 0xE0 LATIN SMALL LETTER A WITH GRAVE
0xC1 LATIN CAPITAL LETTER A WITH ACUTE 0xE1 LATIN SMALL LETTER A WITH ACUTE
0xC2 LATIN CAPITAL LETTER A WITH CIRCUMFLEX 0xE2 LATIN SMALL LETTER A WITH CIRCUMFLEX
0xC3 LATIN CAPITAL LETTER A WITH TILDE 0xE3 LATIN SMALL LETTER A WITH TILDE
0xC4 LATIN CAPITAL LETTER A WITH DIAERESIS 0xE4 LATIN SMALL LETTER A WITH DIAERESIS
0xC5 LATIN CAPITAL LETTER A WITH RING ABOVE 0xE5 LATIN SMALL LETTER A WITH RING ABOVE
0xC6 LATIN CAPITAL LETTER AE 0xE6 LATIN SMALL LETTER AE
0xC7 LATIN CAPITAL LETTER C WITH CEDILLA 0xE7 LATIN SMALL LETTER C WITH CEDILLA
0xC8 LATIN CAPITAL LETTER E WITH GRAVE 0xE8 LATIN SMALL LETTER E WITH GRAVE
0xC9 LATIN CAPITAL LETTER E WITH ACUTE 0xE9 LATIN SMALL LETTER E WITH ACUTE
0xCA LATIN CAPITAL LETTER E WITH CIRCUMFLEX 0xEA LATIN SMALL LETTER E WITH CIRCUMFLEX
0xCB LATIN CAPITAL LETTER E WITH DIAERESIS 0xEB LATIN SMALL LETTER E WITH DIAERESIS
0xCC LATIN CAPITAL LETTER I WITH GRAVE 0xEC LATIN SMALL LETTER I WITH GRAVE
0xCD LATIN CAPITAL LETTER I WITH ACUTE 0xED LATIN SMALL LETTER I WITH ACUTE
0xCE LATIN CAPITAL LETTER I WITH CIRCUMFLEX 0xEE LATIN SMALL LETTER I WITH CIRCUMFLEX
0xCF LATIN CAPITAL LETTER I WITH DIAERESIS 0xEF LATIN SMALL LETTER I WITH DIAERESIS
0xD1 LATIN CAPITAL LETTER N WITH TILDE 0xF1 LATIN SMALL LETTER N WITH TILDE
0xD2 LATIN CAPITAL LETTER O WITH GRAVE 0xF2 LATIN SMALL LETTER O WITH GRAVE
0xD3 LATIN CAPITAL LETTER O WITH ACUTE 0xF3 LATIN SMALL LETTER O WITH ACUTE
0xD4 LATIN CAPITAL LETTER O WITH CIRCUMFLEX 0xF4 LATIN SMALL LETTER O WITH CIRCUMFLEX
0xD5 LATIN CAPITAL LETTER O WITH TILDE 0xF5 LATIN SMALL LETTER O WITH TILDE
0xD6 LATIN CAPITAL LETTER O WITH DIAERESIS 0xF6 LATIN SMALL LETTER O WITH DIAERESIS
0xD7 LATIN CAPITAL LIGATURE OE 0xF7 LATIN SMALL LIGATURE OE
0xD8 LATIN CAPITAL LETTER O WITH STROKE 0xF8 LATIN SMALL LETTER O WITH STROKE
0xD9 LATIN CAPITAL LETTER U WITH GRAVE 0xF9 LATIN SMALL LETTER U WITH GRAVE
0xDA LATIN CAPITAL LETTER U WITH ACUTE 0xFA LATIN SMALL LETTER U WITH ACUTE
0xDB LATIN CAPITAL LETTER U WITH CIRCUMFLEX 0xFB LATIN SMALL LETTER U WITH CIRCUMFLEX
0xDC LATIN CAPITAL LETTER U WITH DIAERESIS 0xFC LATIN SMALL LETTER U WITH DIAERESIS
0xDD LATIN CAPITAL LETTER Y WITH DIAERESIS 0xFD LATIN SMALL LETTER Y WITH DIAERESIS
0xF0 LATIN CAPITAL LETTER ETH 0xD0 LATIN SMALL LETTER ETH
0xFE LATIN CAPITAL LETTER THORN 0xDE LATIN SMALL LETTER THORN