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 |