localhost

Character Sets and Collations

Collation Description
armscii8 (ARMSCII-8 Armenian)
armscii8_bin Armenian, Binary
armscii8_general_ci Armenian, case-insensitive
ascii (US ASCII)
ascii_bin West European (multilingual), Binary
ascii_general_ci West European (multilingual), case-insensitive
big5 (Big5 Traditional Chinese)
big5_bin Traditional Chinese, Binary
big5_chinese_ci Traditional Chinese, case-insensitive
binary (Binary pseudo charset)
binary Binary
cp1250 (Windows Central European)
cp1250_bin Central European (multilingual), Binary
cp1250_croatian_ci Croatian, case-insensitive
cp1250_czech_cs Czech, case-sensitive
cp1250_general_ci Central European (multilingual), case-insensitive
cp1250_polish_ci Polish, case-insensitive
cp1251 (Windows Cyrillic)
cp1251_bin Cyrillic (multilingual), Binary
cp1251_bulgarian_ci Bulgarian, case-insensitive
cp1251_general_ci Cyrillic (multilingual), case-insensitive
cp1251_general_cs Cyrillic (multilingual), case-sensitive
cp1251_ukrainian_ci Ukrainian, case-insensitive
cp1256 (Windows Arabic)
cp1256_bin Arabic, Binary
cp1256_general_ci Arabic, case-insensitive
cp1257 (Windows Baltic)
cp1257_bin Baltic (multilingual), Binary
cp1257_general_ci Baltic (multilingual), case-insensitive
cp1257_lithuanian_ci Lithuanian, case-insensitive
cp850 (DOS West European)
cp850_bin West European (multilingual), Binary
cp850_general_ci West European (multilingual), case-insensitive
cp852 (DOS Central European)
cp852_bin Central European (multilingual), Binary
cp852_general_ci Central European (multilingual), case-insensitive
cp866 (DOS Russian)
cp866_bin Russian, Binary
cp866_general_ci Russian, case-insensitive
cp932 (SJIS for Windows Japanese)
cp932_bin Japanese, Binary
cp932_japanese_ci Japanese, case-insensitive
dec8 (DEC West European)
dec8_bin West European (multilingual), Binary
dec8_swedish_ci Swedish, case-insensitive
eucjpms (UJIS for Windows Japanese)
eucjpms_bin Japanese, Binary
eucjpms_japanese_ci Japanese, case-insensitive
euckr (EUC-KR Korean)
euckr_bin Korean, Binary
euckr_korean_ci Korean, case-insensitive
gb2312 (GB2312 Simplified Chinese)
gb2312_bin Simplified Chinese, Binary
gb2312_chinese_ci Simplified Chinese, case-insensitive
gbk (GBK Simplified Chinese)
gbk_bin Simplified Chinese, Binary
gbk_chinese_ci Simplified Chinese, case-insensitive
geostd8 (GEOSTD8 Georgian)
geostd8_bin Georgian, Binary
geostd8_general_ci Georgian, case-insensitive
greek (ISO 8859-7 Greek)
greek_bin Greek, Binary
greek_general_ci Greek, case-insensitive
hebrew (ISO 8859-8 Hebrew)
hebrew_bin Hebrew, Binary
hebrew_general_ci Hebrew, case-insensitive
hp8 (HP West European)
hp8_bin West European (multilingual), Binary
hp8_english_ci English, case-insensitive
keybcs2 (DOS Kamenicky Czech-Slovak)
keybcs2_bin Czech-Slovak, Binary
keybcs2_general_ci Czech-Slovak, case-insensitive
koi8r (KOI8-R Relcom Russian)
koi8r_bin Russian, Binary
koi8r_general_ci Russian, case-insensitive
koi8u (KOI8-U Ukrainian)
koi8u_bin Ukrainian, Binary
koi8u_general_ci Ukrainian, case-insensitive
latin1 (cp1252 West European)
latin1_bin West European (multilingual), Binary
latin1_danish_ci Danish, case-insensitive
latin1_general_ci West European (multilingual), case-insensitive
latin1_general_cs West European (multilingual), case-sensitive
latin1_german1_ci German (dictionary), case-insensitive
latin1_german2_ci German (phone book), case-insensitive
latin1_spanish_ci Spanish, case-insensitive
latin1_swedish_ci Swedish, case-insensitive
latin2 (ISO 8859-2 Central European)
latin2_bin Central European (multilingual), Binary
latin2_croatian_ci Croatian, case-insensitive
latin2_czech_cs Czech, case-sensitive
latin2_general_ci Central European (multilingual), case-insensitive
latin2_hungarian_ci Hungarian, case-insensitive
latin5 (ISO 8859-9 Turkish)
latin5_bin Turkish, Binary
latin5_turkish_ci Turkish, case-insensitive
latin7 (ISO 8859-13 Baltic)
latin7_bin Baltic (multilingual), Binary
latin7_estonian_cs Estonian, case-sensitive
latin7_general_ci Baltic (multilingual), case-insensitive
latin7_general_cs Baltic (multilingual), case-sensitive
macce (Mac Central European)
macce_bin Central European (multilingual), Binary
macce_general_ci Central European (multilingual), case-insensitive
macroman (Mac West European)
macroman_bin West European (multilingual), Binary
macroman_general_ci West European (multilingual), case-insensitive
sjis (Shift-JIS Japanese)
sjis_bin Japanese, Binary
sjis_japanese_ci Japanese, case-insensitive
swe7 (7bit Swedish)
swe7_bin Swedish, Binary
swe7_swedish_ci Swedish, case-insensitive
tis620 (TIS620 Thai)
tis620_bin Thai, Binary
tis620_thai_ci Thai, case-insensitive
ucs2 (UCS-2 Unicode)
ucs2_bin Unicode (multilingual), Binary
ucs2_czech_ci Czech, case-insensitive
ucs2_danish_ci Danish, case-insensitive
ucs2_esperanto_ci Esperanto, case-insensitive
ucs2_estonian_ci Estonian, case-insensitive
ucs2_general_ci Unicode (multilingual), case-insensitive
ucs2_general_mysql500_ci Unicode (multilingual)
ucs2_hungarian_ci Hungarian, case-insensitive
ucs2_icelandic_ci Icelandic, case-insensitive
ucs2_latvian_ci Latvian, case-insensitive
ucs2_lithuanian_ci Lithuanian, case-insensitive
ucs2_persian_ci Persian, case-insensitive
ucs2_polish_ci Polish, case-insensitive
ucs2_roman_ci West European, case-insensitive
ucs2_romanian_ci Romanian, case-insensitive
ucs2_sinhala_ci unknown, case-insensitive
ucs2_slovak_ci Slovak, case-insensitive
ucs2_slovenian_ci Slovenian, case-insensitive
ucs2_spanish2_ci Traditional Spanish, case-insensitive
ucs2_spanish_ci Spanish, case-insensitive
ucs2_swedish_ci Swedish, case-insensitive
ucs2_turkish_ci Turkish, case-insensitive
ucs2_unicode_ci Unicode (multilingual), case-insensitive
Collation Description
ujis (EUC-JP Japanese)
ujis_bin Japanese, Binary
ujis_japanese_ci Japanese, case-insensitive
utf16 (UTF-16 Unicode)
utf16_bin unknown, Binary
utf16_czech_ci Czech, case-insensitive
utf16_danish_ci Danish, case-insensitive
utf16_esperanto_ci Esperanto, case-insensitive
utf16_estonian_ci Estonian, case-insensitive
utf16_general_ci unknown, case-insensitive
utf16_hungarian_ci Hungarian, case-insensitive
utf16_icelandic_ci Icelandic, case-insensitive
utf16_latvian_ci Latvian, case-insensitive
utf16_lithuanian_ci Lithuanian, case-insensitive
utf16_persian_ci Persian, case-insensitive
utf16_polish_ci Polish, case-insensitive
utf16_roman_ci West European, case-insensitive
utf16_romanian_ci Romanian, case-insensitive
utf16_sinhala_ci unknown, case-insensitive
utf16_slovak_ci Slovak, case-insensitive
utf16_slovenian_ci Slovenian, case-insensitive
utf16_spanish2_ci Traditional Spanish, case-insensitive
utf16_spanish_ci Spanish, case-insensitive
utf16_swedish_ci Swedish, case-insensitive
utf16_turkish_ci Turkish, case-insensitive
utf16_unicode_ci Unicode (multilingual), case-insensitive
utf32 (UTF-32 Unicode)
utf32_bin unknown, Binary
utf32_czech_ci Czech, case-insensitive
utf32_danish_ci Danish, case-insensitive
utf32_esperanto_ci Esperanto, case-insensitive
utf32_estonian_ci Estonian, case-insensitive
utf32_general_ci unknown, case-insensitive
utf32_hungarian_ci Hungarian, case-insensitive
utf32_icelandic_ci Icelandic, case-insensitive
utf32_latvian_ci Latvian, case-insensitive
utf32_lithuanian_ci Lithuanian, case-insensitive
utf32_persian_ci Persian, case-insensitive
utf32_polish_ci Polish, case-insensitive
utf32_roman_ci West European, case-insensitive
utf32_romanian_ci Romanian, case-insensitive
utf32_sinhala_ci unknown, case-insensitive
utf32_slovak_ci Slovak, case-insensitive
utf32_slovenian_ci Slovenian, case-insensitive
utf32_spanish2_ci Traditional Spanish, case-insensitive
utf32_spanish_ci Spanish, case-insensitive
utf32_swedish_ci Swedish, case-insensitive
utf32_turkish_ci Turkish, case-insensitive
utf32_unicode_ci Unicode (multilingual), case-insensitive
utf8 (UTF-8 Unicode)
utf8_bin Unicode (multilingual), Binary
utf8_czech_ci Czech, case-insensitive
utf8_danish_ci Danish, case-insensitive
utf8_esperanto_ci Esperanto, case-insensitive
utf8_estonian_ci Estonian, case-insensitive
utf8_general_ci Unicode (multilingual), case-insensitive
utf8_general_mysql500_ci Unicode (multilingual)
utf8_hungarian_ci Hungarian, case-insensitive
utf8_icelandic_ci Icelandic, case-insensitive
utf8_latvian_ci Latvian, case-insensitive
utf8_lithuanian_ci Lithuanian, case-insensitive
utf8_persian_ci Persian, case-insensitive
utf8_polish_ci Polish, case-insensitive
utf8_roman_ci West European, case-insensitive
utf8_romanian_ci Romanian, case-insensitive
utf8_sinhala_ci unknown, case-insensitive
utf8_slovak_ci Slovak, case-insensitive
utf8_slovenian_ci Slovenian, case-insensitive
utf8_spanish2_ci Traditional Spanish, case-insensitive
utf8_spanish_ci Spanish, case-insensitive
utf8_swedish_ci Swedish, case-insensitive
utf8_turkish_ci Turkish, case-insensitive
utf8_unicode_ci Unicode (multilingual), case-insensitive
utf8mb4 (UTF-8 Unicode)
utf8mb4_bin unknown, Binary
utf8mb4_czech_ci Czech, case-insensitive
utf8mb4_danish_ci Danish, case-insensitive
utf8mb4_esperanto_ci Esperanto, case-insensitive
utf8mb4_estonian_ci Estonian, case-insensitive
utf8mb4_general_ci unknown, case-insensitive
utf8mb4_hungarian_ci Hungarian, case-insensitive
utf8mb4_icelandic_ci Icelandic, case-insensitive
utf8mb4_latvian_ci Latvian, case-insensitive
utf8mb4_lithuanian_ci Lithuanian, case-insensitive
utf8mb4_persian_ci Persian, case-insensitive
utf8mb4_polish_ci Polish, case-insensitive
utf8mb4_roman_ci West European, case-insensitive
utf8mb4_romanian_ci Romanian, case-insensitive
utf8mb4_sinhala_ci unknown, case-insensitive
utf8mb4_slovak_ci Slovak, case-insensitive
utf8mb4_slovenian_ci Slovenian, case-insensitive
utf8mb4_spanish2_ci Traditional Spanish, case-insensitive
utf8mb4_spanish_ci Spanish, case-insensitive
utf8mb4_swedish_ci Swedish, case-insensitive
utf8mb4_turkish_ci Turkish, case-insensitive
utf8mb4_unicode_ci Unicode (multilingual), case-insensitive