-------------- select "Show Collation" --------------
Show Collation
Show Collation
-------------- 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_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_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
cp1251_bulgarian_cicp125114Yes1
cp1251_ukrainian_cicp125123Yes1
cp1251_bincp125150Yes1
cp1251_general_cicp125151YesYes1
cp1251_general_cscp125152Yes1
cp1256_general_cicp125657YesYes1
cp1256_bincp125667Yes1
cp1257_lithuanian_cicp125729Yes1
cp1257_bincp125758Yes1
cp1257_general_cicp125759YesYes1
binarybinary63YesYes1
geostd8_general_cigeostd892YesYes1
geostd8_bingeostd893Yes1
cp932_japanese_cicp93295YesYes1
cp932_bincp93296Yes1
eucjpms_japanese_cieucjpms97YesYes1
eucjpms_bineucjpms98Yes1