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 |