-------------- show collation --------------
CollationCharsetIdDefaultCompiledSortlen
big5_chinese_cibig51YesYes1
big5_binbig584Yes1
dec8_swedish_cidec83YesYes1
dec8_bindec869Yes1
cp850_general_cicp8504YesYes1
cp850_bincp85080Yes1
hp8_english_cihp86YesYes1
hp8_binhp872Yes1
koi8r_general_cikoi8r7YesYes1
koi8r_binkoi8r74Yes1
latin1_german1_cilatin15Yes1
latin1_swedish_cilatin18YesYes1
latin1_danish_cilatin115Yes1
latin1_german2_cilatin131Yes2
latin1_binlatin147Yes1
latin1_general_cilatin148Yes1
latin1_general_cslatin149Yes1
latin1_spanish_cilatin194Yes1
latin2_czech_cslatin22Yes4
latin2_general_cilatin29YesYes1
latin2_hungarian_cilatin221Yes1
latin2_croatian_cilatin227Yes1
latin2_binlatin277Yes1
swe7_swedish_ciswe710YesYes1
swe7_binswe782Yes1
ascii_general_ciascii11YesYes1
ascii_binascii65Yes1
ujis_japanese_ciujis12YesYes1
ujis_binujis91Yes1
sjis_japanese_cisjis13YesYes1
sjis_binsjis88Yes1
hebrew_general_cihebrew16YesYes1
hebrew_binhebrew71Yes1
tis620_thai_citis62018YesYes4
tis620_bintis62089Yes1
euckr_korean_cieuckr19YesYes1
euckr_bineuckr85Yes1
koi8u_general_cikoi8u22YesYes1
koi8u_binkoi8u75Yes1
gb2312_chinese_cigb231224YesYes1
gb2312_bingb231286Yes1
greek_general_cigreek25YesYes1
greek_bingreek70Yes1
cp1250_general_cicp125026YesYes1
cp1250_czech_cscp125034Yes2
cp1250_croatian_cicp125044Yes1
cp1250_bincp125066Yes1
cp1250_polish_cicp125099Yes1
gbk_chinese_cigbk28YesYes1
gbk_bingbk87Yes1
latin5_turkish_cilatin530YesYes1
latin5_binlatin578Yes1
armscii8_general_ciarmscii832YesYes1
armscii8_binarmscii864Yes1
utf8_general_ciutf833YesYes1
utf8_binutf883Yes1
utf8_unicode_ciutf8192Yes8
utf8_icelandic_ciutf8193Yes8
utf8_latvian_ciutf8194Yes8
utf8_romanian_ciutf8195Yes8
utf8_slovenian_ciutf8196Yes8
utf8_polish_ciutf8197Yes8
utf8_estonian_ciutf8198Yes8
utf8_spanish_ciutf8199Yes8
utf8_swedish_ciutf8200Yes8
utf8_turkish_ciutf8201Yes8
utf8_czech_ciutf8202Yes8
utf8_danish_ciutf8203Yes8
utf8_lithuanian_ciutf8204Yes8
utf8_slovak_ciutf8205Yes8
utf8_spanish2_ciutf8206Yes8
utf8_roman_ciutf8207Yes8
utf8_persian_ciutf8208Yes8
utf8_esperanto_ciutf8209Yes8
utf8_hungarian_ciutf8210Yes8
utf8_sinhala_ciutf8211Yes8
utf8_german2_ciutf8212Yes8
utf8_croatian_ciutf8213Yes8
utf8_unicode_520_ciutf8214Yes8
utf8_vietnamese_ciutf8215Yes8
utf8_general_mysql500_ciutf8223Yes1
ucs2_general_ciucs235YesYes1
ucs2_binucs290Yes1
ucs2_unicode_ciucs2128Yes8
ucs2_icelandic_ciucs2129Yes8
ucs2_latvian_ciucs2130Yes8
ucs2_romanian_ciucs2131Yes8
ucs2_slovenian_ciucs2132Yes8
ucs2_polish_ciucs2133Yes8
ucs2_estonian_ciucs2134Yes8
ucs2_spanish_ciucs2135Yes8
ucs2_swedish_ciucs2136Yes8
ucs2_turkish_ciucs2137Yes8
ucs2_czech_ciucs2138Yes8
ucs2_danish_ciucs2139Yes8
ucs2_lithuanian_ciucs2140Yes8
ucs2_slovak_ciucs2141Yes8
ucs2_spanish2_ciucs2142Yes8
ucs2_roman_ciucs2143Yes8
ucs2_persian_ciucs2144Yes8
ucs2_esperanto_ciucs2145Yes8
ucs2_hungarian_ciucs2146Yes8
ucs2_sinhala_ciucs2147Yes8
ucs2_german2_ciucs2148Yes8
ucs2_croatian_ciucs2149Yes8
ucs2_unicode_520_ciucs2150Yes8
ucs2_vietnamese_ciucs2151Yes8
ucs2_general_mysql500_ciucs2159Yes1
cp866_general_cicp86636YesYes1
cp866_bincp86668Yes1
keybcs2_general_cikeybcs237YesYes1
keybcs2_binkeybcs273Yes1
macce_general_cimacce38YesYes1
macce_binmacce43Yes1
macroman_general_cimacroman39YesYes1
macroman_binmacroman53Yes1
cp852_general_cicp85240YesYes1
cp852_bincp85281Yes1
latin7_estonian_cslatin720Yes1
latin7_general_cilatin741YesYes1
latin7_general_cslatin742Yes1
latin7_binlatin779Yes1
utf8mb4_general_ciutf8mb445YesYes1
utf8mb4_binutf8mb446Yes1
utf8mb4_unicode_ciutf8mb4224Yes8
utf8mb4_icelandic_ciutf8mb4225Yes8
utf8mb4_latvian_ciutf8mb4226Yes8
utf8mb4_romanian_ciutf8mb4227Yes8
utf8mb4_slovenian_ciutf8mb4228Yes8
utf8mb4_polish_ciutf8mb4229Yes8
utf8mb4_estonian_ciutf8mb4230Yes8
utf8mb4_spanish_ciutf8mb4231Yes8
utf8mb4_swedish_ciutf8mb4232Yes8
utf8mb4_turkish_ciutf8mb4233Yes8
utf8mb4_czech_ciutf8mb4234Yes8
utf8mb4_danish_ciutf8mb4235Yes8
utf8mb4_lithuanian_ciutf8mb4236Yes8
utf8mb4_slovak_ciutf8mb4237Yes8
utf8mb4_spanish2_ciutf8mb4238Yes8
utf8mb4_roman_ciutf8mb4239Yes8
utf8mb4_persian_ciutf8mb4240Yes8
utf8mb4_esperanto_ciutf8mb4241Yes8
utf8mb4_hungarian_ciutf8mb4242Yes8
utf8mb4_sinhala_ciutf8mb4243Yes8
utf8mb4_german2_ciutf8mb4244Yes8
utf8mb4_croatian_ciutf8mb4245Yes8
utf8mb4_unicode_520_ciutf8mb4246Yes8
utf8mb4_vietnamese_ciutf8mb4247Yes8
cp1251_bulgarian_cicp125114Yes1
cp1251_ukrainian_cicp125123Yes1
cp1251_bincp125150Yes1
cp1251_general_cicp125151YesYes1
cp1251_general_cscp125152Yes1
utf16_general_ciutf1654YesYes1
utf16_binutf1655Yes1
utf16_unicode_ciutf16101Yes8
utf16_icelandic_ciutf16102Yes8
utf16_latvian_ciutf16103Yes8
utf16_romanian_ciutf16104Yes8
utf16_slovenian_ciutf16105Yes8
utf16_polish_ciutf16106Yes8
utf16_estonian_ciutf16107Yes8
utf16_spanish_ciutf16108Yes8
utf16_swedish_ciutf16109Yes8
utf16_turkish_ciutf16110Yes8
utf16_czech_ciutf16111Yes8
utf16_danish_ciutf16112Yes8
utf16_lithuanian_ciutf16113Yes8
utf16_slovak_ciutf16114Yes8
utf16_spanish2_ciutf16115Yes8
utf16_roman_ciutf16116Yes8
utf16_persian_ciutf16117Yes8
utf16_esperanto_ciutf16118Yes8
utf16_hungarian_ciutf16119Yes8
utf16_sinhala_ciutf16120Yes8
utf16_german2_ciutf16121Yes8
utf16_croatian_ciutf16122Yes8
utf16_unicode_520_ciutf16123Yes8
utf16_vietnamese_ciutf16124Yes8
utf16le_general_ciutf16le56YesYes1
utf16le_binutf16le62Yes1
cp1256_general_cicp125657YesYes1
cp1256_bincp125667Yes1
cp1257_lithuanian_cicp125729Yes1
cp1257_bincp125758Yes1
cp1257_general_cicp125759YesYes1
utf32_general_ciutf3260YesYes1
utf32_binutf3261Yes1
utf32_unicode_ciutf32160Yes8
utf32_icelandic_ciutf32161Yes8
utf32_latvian_ciutf32162Yes8
utf32_romanian_ciutf32163Yes8
utf32_slovenian_ciutf32164Yes8
utf32_polish_ciutf32165Yes8
utf32_estonian_ciutf32166Yes8
utf32_spanish_ciutf32167Yes8
utf32_swedish_ciutf32168Yes8
utf32_turkish_ciutf32169Yes8
utf32_czech_ciutf32170Yes8
utf32_danish_ciutf32171Yes8
utf32_lithuanian_ciutf32172Yes8
utf32_slovak_ciutf32173Yes8
utf32_spanish2_ciutf32174Yes8
utf32_roman_ciutf32175Yes8
utf32_persian_ciutf32176Yes8
utf32_esperanto_ciutf32177Yes8
utf32_hungarian_ciutf32178Yes8
utf32_sinhala_ciutf32179Yes8
utf32_german2_ciutf32180Yes8
utf32_croatian_ciutf32181Yes8
utf32_unicode_520_ciutf32182Yes8
utf32_vietnamese_ciutf32183Yes8
binarybinary63YesYes1
geostd8_general_cigeostd892YesYes1
geostd8_bingeostd893Yes1
cp932_japanese_cicp93295YesYes1
cp932_bincp93296Yes1
eucjpms_japanese_cieucjpms97YesYes1
eucjpms_bineucjpms98Yes1