Collation | Description |
---|---|
armscii8 | |
armscii8_bin | Armenian, Binary |
armscii8_general_ci | Armenian, case-insensitive |
ascii | |
ascii_bin | West European (multilingual), Binary |
ascii_general_ci | West European (multilingual), case-insensitive |
big5 | |
big5_bin | Traditional Chinese, Binary |
big5_chinese_ci | Traditional Chinese, case-insensitive |
binary | |
binary | Binary |
cp1250 | |
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 | |
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 | |
cp1256_bin | Arabic, Binary |
cp1256_general_ci | Arabic, case-insensitive |
cp1257 | |
cp1257_bin | Baltic (multilingual), Binary |
cp1257_general_ci | Baltic (multilingual), case-insensitive |
cp1257_lithuanian_ci | Lithuanian, case-insensitive |
cp850 | |
cp850_bin | West European (multilingual), Binary |
cp850_general_ci | West European (multilingual), case-insensitive |
cp852 | |
cp852_bin | Central European (multilingual), Binary |
cp852_general_ci | Central European (multilingual), case-insensitive |
cp866 | |
cp866_bin | Russian, Binary |
cp866_general_ci | Russian, case-insensitive |
Collation | Description |
---|---|
cp932 | |
cp932_bin | Japanese, Binary |
cp932_japanese_ci | Japanese, case-insensitive |
dec8 | |
dec8_bin | West European (multilingual), Binary |
dec8_swedish_ci | Swedish, case-insensitive |
eucjpms | |
eucjpms_bin | Japanese, Binary |
eucjpms_japanese_ci | Japanese, case-insensitive |
euckr | |
euckr_bin | Korean, Binary |
euckr_korean_ci | Korean, case-insensitive |
gb2312 | |
gb2312_bin | Simplified Chinese, Binary |
gb2312_chinese_ci | Simplified Chinese, case-insensitive |
gbk | |
gbk_bin | Simplified Chinese, Binary |
gbk_chinese_ci | Simplified Chinese, case-insensitive |
geostd8 | |
geostd8_bin | Georgian, Binary |
geostd8_general_ci | Georgian, case-insensitive |
greek | |
greek_bin | Greek, Binary |
greek_general_ci | Greek, case-insensitive |
hebrew | |
hebrew_bin | Hebrew, Binary |
hebrew_general_ci | Hebrew, case-insensitive |
hp8 | |
hp8_bin | West European (multilingual), Binary |
hp8_english_ci | English, case-insensitive |
keybcs2 | |
keybcs2_bin | Czech-Slovak, Binary |
keybcs2_general_ci | Czech-Slovak, case-insensitive |
koi8r | |
koi8r_bin | Russian, Binary |
koi8r_general_ci | Russian, case-insensitive |
koi8u | |
koi8u_bin | Ukrainian, Binary |
koi8u_general_ci | Ukrainian, case-insensitive |
Collation | Description |
---|---|
latin1 | |
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 | |
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 | |
latin5_bin | Turkish, Binary |
latin5_turkish_ci | Turkish, case-insensitive |
latin7 | |
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 | |
macce_bin | Central European (multilingual), Binary |
macce_general_ci | Central European (multilingual), case-insensitive |
macroman | |
macroman_bin | West European (multilingual), Binary |
macroman_general_ci | West European (multilingual), case-insensitive |
sjis | |
sjis_bin | Japanese, Binary |
sjis_japanese_ci | Japanese, case-insensitive |
swe7 | |
swe7_bin | Swedish, Binary |
swe7_swedish_ci | Swedish, case-insensitive |
tis620 | |
tis620_bin | Thai, Binary |
tis620_thai_ci | Thai, case-insensitive |
ucs2 | |
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 | |
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 |
Collation | Description |
---|---|
utf8 | |
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 |