Check all character sets & collations in MariaDB / MySQL
SHOW COLLATION [LIKE 'pattern' | WHERE expr]
select * from information_schema.collations;Example:
SHOW COLLATION LIKE 'latin1%';
Collation |Charset|Id |Default|Compiled|Sortle
-----------------------+-------+----+-------+--------+------
latin1_german1_ci |latin1 | 5| |Yes |
latin1_swedish_ci |latin1 | 8|Yes |Yes |
latin1_danish_ci |latin1 | 15| |Yes |
latin1_german2_ci |latin1 | 31| |Yes |
latin1_bin |latin1 | 47| |Yes |
latin1_general_ci |latin1 | 48| |Yes |
latin1_general_cs |latin1 | 49| |Yes |
latin1_spanish_ci |latin1 | 94| |Yes |
latin1_swedish_nopad_ci|latin1 |1032| |Yes |
latin1_nopad_bin |latin1 |1071| |Yes | List of all collations & charactersets present in the MariaDB/MySQL:
Collation |Charset |Id |Default|Compiled|Sortlen|
----------------------------+--------+----+-------+--------+-------+
big5_chinese_ci |big5 | 1|Yes |Yes | 1|
big5_bin |big5 | 84| |Yes | 1|
big5_chinese_nopad_ci |big5 |1025| |Yes | 1|
big5_nopad_bin |big5 |1108| |Yes | 1|
dec8_swedish_ci |dec8 | 3|Yes |Yes | 1|
dec8_bin |dec8 | 69| |Yes | 1|
dec8_swedish_nopad_ci |dec8 |1027| |Yes | 1|
dec8_nopad_bin |dec8 |1093| |Yes | 1|
cp850_general_ci |cp850 | 4|Yes |Yes | 1|
cp850_bin |cp850 | 80| |Yes | 1|
cp850_general_nopad_ci |cp850 |1028| |Yes | 1|
cp850_nopad_bin |cp850 |1104| |Yes | 1|
hp8_english_ci |hp8 | 6|Yes |Yes | 1|
hp8_bin |hp8 | 72| |Yes | 1|
hp8_english_nopad_ci |hp8 |1030| |Yes | 1|
hp8_nopad_bin |hp8 |1096| |Yes | 1|
koi8r_general_ci |koi8r | 7|Yes |Yes | 1|
koi8r_bin |koi8r | 74| |Yes | 1|
koi8r_general_nopad_ci |koi8r |1031| |Yes | 1|
koi8r_nopad_bin |koi8r |1098| |Yes | 1|
latin1_german1_ci |latin1 | 5| |Yes | 1|
latin1_swedish_ci |latin1 | 8|Yes |Yes | 1|
latin1_danish_ci |latin1 | 15| |Yes | 1|
latin1_german2_ci |latin1 | 31| |Yes | 2|
latin1_bin |latin1 | 47| |Yes | 1|
latin1_general_ci |latin1 | 48| |Yes | 1|
latin1_general_cs |latin1 | 49| |Yes | 1|
latin1_spanish_ci |latin1 | 94| |Yes | 1|
latin1_swedish_nopad_ci |latin1 |1032| |Yes | 1|
latin1_nopad_bin |latin1 |1071| |Yes | 1|
latin2_czech_cs |latin2 | 2| |Yes | 4|
latin2_general_ci |latin2 | 9|Yes |Yes | 1|
latin2_hungarian_ci |latin2 | 21| |Yes | 1|
latin2_croatian_ci |latin2 | 27| |Yes | 1|
latin2_bin |latin2 | 77| |Yes | 1|
latin2_general_nopad_ci |latin2 |1033| |Yes | 1|
latin2_nopad_bin |latin2 |1101| |Yes | 1|
swe7_swedish_ci |swe7 | 10|Yes |Yes | 1|
swe7_bin |swe7 | 82| |Yes | 1|
swe7_swedish_nopad_ci |swe7 |1034| |Yes | 1|
swe7_nopad_bin |swe7 |1106| |Yes | 1|
ascii_general_ci |ascii | 11|Yes |Yes | 1|
ascii_bin |ascii | 65| |Yes | 1|
ascii_general_nopad_ci |ascii |1035| |Yes | 1|
ascii_nopad_bin |ascii |1089| |Yes | 1|
ujis_japanese_ci |ujis | 12|Yes |Yes | 1|
ujis_bin |ujis | 91| |Yes | 1|
ujis_japanese_nopad_ci |ujis |1036| |Yes | 1|
ujis_nopad_bin |ujis |1115| |Yes | 1|
sjis_japanese_ci |sjis | 13|Yes |Yes | 1|
sjis_bin |sjis | 88| |Yes | 1|
sjis_japanese_nopad_ci |sjis |1037| |Yes | 1|
sjis_nopad_bin |sjis |1112| |Yes | 1|
hebrew_general_ci |hebrew | 16|Yes |Yes | 1|
hebrew_bin |hebrew | 71| |Yes | 1|
hebrew_general_nopad_ci |hebrew |1040| |Yes | 1|
hebrew_nopad_bin |hebrew |1095| |Yes | 1|
tis620_thai_ci |tis620 | 18|Yes |Yes | 4|
tis620_bin |tis620 | 89| |Yes | 1|
tis620_thai_nopad_ci |tis620 |1042| |Yes | 4|
tis620_nopad_bin |tis620 |1113| |Yes | 1|
euckr_korean_ci |euckr | 19|Yes |Yes | 1|
euckr_bin |euckr | 85| |Yes | 1|
euckr_korean_nopad_ci |euckr |1043| |Yes | 1|
euckr_nopad_bin |euckr |1109| |Yes | 1|
koi8u_general_ci |koi8u | 22|Yes |Yes | 1|
koi8u_bin |koi8u | 75| |Yes | 1|
koi8u_general_nopad_ci |koi8u |1046| |Yes | 1|
koi8u_nopad_bin |koi8u |1099| |Yes | 1|
gb2312_chinese_ci |gb2312 | 24|Yes |Yes | 1|
gb2312_bin |gb2312 | 86| |Yes | 1|
gb2312_chinese_nopad_ci |gb2312 |1048| |Yes | 1|
gb2312_nopad_bin |gb2312 |1110| |Yes | 1|
greek_general_ci |greek | 25|Yes |Yes | 1|
greek_bin |greek | 70| |Yes | 1|
greek_general_nopad_ci |greek |1049| |Yes | 1|
greek_nopad_bin |greek |1094| |Yes | 1|
cp1250_general_ci |cp1250 | 26|Yes |Yes | 1|
cp1250_czech_cs |cp1250 | 34| |Yes | 2|
cp1250_croatian_ci |cp1250 | 44| |Yes | 1|
cp1250_bin |cp1250 | 66| |Yes | 1|
cp1250_polish_ci |cp1250 | 99| |Yes | 1|
cp1250_general_nopad_ci |cp1250 |1050| |Yes | 1|
cp1250_nopad_bin |cp1250 |1090| |Yes | 1|
gbk_chinese_ci |gbk | 28|Yes |Yes | 1|
gbk_bin |gbk | 87| |Yes | 1|
gbk_chinese_nopad_ci |gbk |1052| |Yes | 1|
gbk_nopad_bin |gbk |1111| |Yes | 1|
latin5_turkish_ci |latin5 | 30|Yes |Yes | 1|
latin5_bin |latin5 | 78| |Yes | 1|
latin5_turkish_nopad_ci |latin5 |1054| |Yes | 1|
latin5_nopad_bin |latin5 |1102| |Yes | 1|
armscii8_general_ci |armscii8| 32|Yes |Yes | 1|
armscii8_bin |armscii8| 64| |Yes | 1|
armscii8_general_nopad_ci |armscii8|1056| |Yes | 1|
armscii8_nopad_bin |armscii8|1088| |Yes | 1|
utf8mb3_general_ci |utf8mb3 | 33|Yes |Yes | 1|
utf8mb3_bin |utf8mb3 | 83| |Yes | 1|
utf8mb3_unicode_ci |utf8mb3 | 192| |Yes | 8|
utf8mb3_icelandic_ci |utf8mb3 | 193| |Yes | 8|
utf8mb3_latvian_ci |utf8mb3 | 194| |Yes | 8|
utf8mb3_romanian_ci |utf8mb3 | 195| |Yes | 8|
utf8mb3_slovenian_ci |utf8mb3 | 196| |Yes | 8|
utf8mb3_polish_ci |utf8mb3 | 197| |Yes | 8|
utf8mb3_estonian_ci |utf8mb3 | 198| |Yes | 8|
utf8mb3_spanish_ci |utf8mb3 | 199| |Yes | 8|
utf8mb3_swedish_ci |utf8mb3 | 200| |Yes | 8|
utf8mb3_turkish_ci |utf8mb3 | 201| |Yes | 8|
utf8mb3_czech_ci |utf8mb3 | 202| |Yes | 8|
utf8mb3_danish_ci |utf8mb3 | 203| |Yes | 8|
utf8mb3_lithuanian_ci |utf8mb3 | 204| |Yes | 8|
utf8mb3_slovak_ci |utf8mb3 | 205| |Yes | 8|
utf8mb3_spanish2_ci |utf8mb3 | 206| |Yes | 8|
utf8mb3_roman_ci |utf8mb3 | 207| |Yes | 8|
utf8mb3_persian_ci |utf8mb3 | 208| |Yes | 8|
utf8mb3_esperanto_ci |utf8mb3 | 209| |Yes | 8|
utf8mb3_hungarian_ci |utf8mb3 | 210| |Yes | 8|
utf8mb3_sinhala_ci |utf8mb3 | 211| |Yes | 8|
utf8mb3_german2_ci |utf8mb3 | 212| |Yes | 8|
utf8mb3_croatian_mysql561_ci|utf8mb3 | 213| |Yes | 8|
utf8mb3_unicode_520_ci |utf8mb3 | 214| |Yes | 8|
utf8mb3_vietnamese_ci |utf8mb3 | 215| |Yes | 8|
utf8mb3_general_mysql500_ci |utf8mb3 | 223| |Yes | 1|
utf8mb3_croatian_ci |utf8mb3 | 576| |Yes | 8|
utf8mb3_myanmar_ci |utf8mb3 | 577| |Yes | 8|
utf8mb3_thai_520_w2 |utf8mb3 | 578| |Yes | 4|
utf8mb3_general_nopad_ci |utf8mb3 |1057| |Yes | 1|
utf8mb3_nopad_bin |utf8mb3 |1107| |Yes | 1|
utf8mb3_unicode_nopad_ci |utf8mb3 |1216| |Yes | 8|
utf8mb3_unicode_520_nopad_ci|utf8mb3 |1238| |Yes | 8|
ucs2_general_ci |ucs2 | 35|Yes |Yes | 1|
ucs2_bin |ucs2 | 90| |Yes | 1|
ucs2_unicode_ci |ucs2 | 128| |Yes | 8|
ucs2_icelandic_ci |ucs2 | 129| |Yes | 8|
ucs2_latvian_ci |ucs2 | 130| |Yes | 8|
ucs2_romanian_ci |ucs2 | 131| |Yes | 8|
ucs2_slovenian_ci |ucs2 | 132| |Yes | 8|
ucs2_polish_ci |ucs2 | 133| |Yes | 8|
ucs2_estonian_ci |ucs2 | 134| |Yes | 8|
ucs2_spanish_ci |ucs2 | 135| |Yes | 8|
ucs2_swedish_ci |ucs2 | 136| |Yes | 8|
ucs2_turkish_ci |ucs2 | 137| |Yes | 8|
ucs2_czech_ci |ucs2 | 138| |Yes | 8|
ucs2_danish_ci |ucs2 | 139| |Yes | 8|
ucs2_lithuanian_ci |ucs2 | 140| |Yes | 8|
ucs2_slovak_ci |ucs2 | 141| |Yes | 8|
ucs2_spanish2_ci |ucs2 | 142| |Yes | 8|
ucs2_roman_ci |ucs2 | 143| |Yes | 8|
ucs2_persian_ci |ucs2 | 144| |Yes | 8|
ucs2_esperanto_ci |ucs2 | 145| |Yes | 8|
ucs2_hungarian_ci |ucs2 | 146| |Yes | 8|
ucs2_sinhala_ci |ucs2 | 147| |Yes | 8|
ucs2_german2_ci |ucs2 | 148| |Yes | 8|
ucs2_croatian_mysql561_ci |ucs2 | 149| |Yes | 8|
ucs2_unicode_520_ci |ucs2 | 150| |Yes | 8|
ucs2_vietnamese_ci |ucs2 | 151| |Yes | 8|
ucs2_general_mysql500_ci |ucs2 | 159| |Yes | 1|
ucs2_croatian_ci |ucs2 | 640| |Yes | 8|
ucs2_myanmar_ci |ucs2 | 641| |Yes | 8|
ucs2_thai_520_w2 |ucs2 | 642| |Yes | 4|
ucs2_general_nopad_ci |ucs2 |1059| |Yes | 1|
ucs2_nopad_bin |ucs2 |1114| |Yes | 1|
ucs2_unicode_nopad_ci |ucs2 |1152| |Yes | 8|
ucs2_unicode_520_nopad_ci |ucs2 |1174| |Yes | 8|
cp866_general_ci |cp866 | 36|Yes |Yes | 1|
cp866_bin |cp866 | 68| |Yes | 1|
cp866_general_nopad_ci |cp866 |1060| |Yes | 1|
cp866_nopad_bin |cp866 |1092| |Yes | 1|
keybcs2_general_ci |keybcs2 | 37|Yes |Yes | 1|
keybcs2_bin |keybcs2 | 73| |Yes | 1|
keybcs2_general_nopad_ci |keybcs2 |1061| |Yes | 1|
keybcs2_nopad_bin |keybcs2 |1097| |Yes | 1|
macce_general_ci |macce | 38|Yes |Yes | 1|
macce_bin |macce | 43| |Yes | 1|
macce_general_nopad_ci |macce |1062| |Yes | 1|
macce_nopad_bin |macce |1067| |Yes | 1|
macroman_general_ci |macroman| 39|Yes |Yes | 1|
macroman_bin |macroman| 53| |Yes | 1|
macroman_general_nopad_ci |macroman|1063| |Yes | 1|
macroman_nopad_bin |macroman|1077| |Yes | 1|
cp852_general_ci |cp852 | 40|Yes |Yes | 1|
cp852_bin |cp852 | 81| |Yes | 1|
cp852_general_nopad_ci |cp852 |1064| |Yes | 1|
cp852_nopad_bin |cp852 |1105| |Yes | 1|
latin7_estonian_cs |latin7 | 20| |Yes | 1|
latin7_general_ci |latin7 | 41|Yes |Yes | 1|
latin7_general_cs |latin7 | 42| |Yes | 1|
latin7_bin |latin7 | 79| |Yes | 1|
latin7_general_nopad_ci |latin7 |1065| |Yes | 1|
latin7_nopad_bin |latin7 |1103| |Yes | 1|
utf8mb4_general_ci |utf8mb4 | 45|Yes |Yes | 1|
utf8mb4_bin |utf8mb4 | 46| |Yes | 1|
utf8mb4_unicode_ci |utf8mb4 | 224| |Yes | 8|
utf8mb4_icelandic_ci |utf8mb4 | 225| |Yes | 8|
utf8mb4_latvian_ci |utf8mb4 | 226| |Yes | 8|
utf8mb4_romanian_ci |utf8mb4 | 227| |Yes | 8|
utf8mb4_slovenian_ci |utf8mb4 | 228| |Yes | 8|
utf8mb4_polish_ci |utf8mb4 | 229| |Yes | 8|
utf8mb4_estonian_ci |utf8mb4 | 230| |Yes | 8|
utf8mb4_spanish_ci |utf8mb4 | 231| |Yes | 8|
utf8mb4_swedish_ci |utf8mb4 | 232| |Yes | 8|
utf8mb4_turkish_ci |utf8mb4 | 233| |Yes | 8|
utf8mb4_czech_ci |utf8mb4 | 234| |Yes | 8|
utf8mb4_danish_ci |utf8mb4 | 235| |Yes | 8|
utf8mb4_lithuanian_ci |utf8mb4 | 236| |Yes | 8|
utf8mb4_slovak_ci |utf8mb4 | 237| |Yes | 8|
utf8mb4_spanish2_ci |utf8mb4 | 238| |Yes | 8|
utf8mb4_roman_ci |utf8mb4 | 239| |Yes | 8|
utf8mb4_persian_ci |utf8mb4 | 240| |Yes | 8|
utf8mb4_esperanto_ci |utf8mb4 | 241| |Yes | 8|
utf8mb4_hungarian_ci |utf8mb4 | 242| |Yes | 8|
utf8mb4_sinhala_ci |utf8mb4 | 243| |Yes | 8|
utf8mb4_german2_ci |utf8mb4 | 244| |Yes | 8|
utf8mb4_croatian_mysql561_ci|utf8mb4 | 245| |Yes | 8|
utf8mb4_unicode_520_ci |utf8mb4 | 246| |Yes | 8|
utf8mb4_vietnamese_ci |utf8mb4 | 247| |Yes | 8|
utf8mb4_croatian_ci |utf8mb4 | 608| |Yes | 8|
utf8mb4_myanmar_ci |utf8mb4 | 609| |Yes | 8|
utf8mb4_thai_520_w2 |utf8mb4 | 610| |Yes | 4|
utf8mb4_general_nopad_ci |utf8mb4 |1069| |Yes | 1|
utf8mb4_nopad_bin |utf8mb4 |1070| |Yes | 1|
utf8mb4_unicode_nopad_ci |utf8mb4 |1248| |Yes | 8|
utf8mb4_unicode_520_nopad_ci|utf8mb4 |1270| |Yes | 8|
cp1251_bulgarian_ci |cp1251 | 14| |Yes | 1|
cp1251_ukrainian_ci |cp1251 | 23| |Yes | 1|
cp1251_bin |cp1251 | 50| |Yes | 1|
cp1251_general_ci |cp1251 | 51|Yes |Yes | 1|
cp1251_general_cs |cp1251 | 52| |Yes | 1|
cp1251_nopad_bin |cp1251 |1074| |Yes | 1|
cp1251_general_nopad_ci |cp1251 |1075| |Yes | 1|
utf16_general_ci |utf16 | 54|Yes |Yes | 1|
utf16_bin |utf16 | 55| |Yes | 1|
utf16_unicode_ci |utf16 | 101| |Yes | 8|
utf16_icelandic_ci |utf16 | 102| |Yes | 8|
utf16_latvian_ci |utf16 | 103| |Yes | 8|
utf16_romanian_ci |utf16 | 104| |Yes | 8|
utf16_slovenian_ci |utf16 | 105| |Yes | 8|
utf16_polish_ci |utf16 | 106| |Yes | 8|
utf16_estonian_ci |utf16 | 107| |Yes | 8|
utf16_spanish_ci |utf16 | 108| |Yes | 8|
utf16_swedish_ci |utf16 | 109| |Yes | 8|
utf16_turkish_ci |utf16 | 110| |Yes | 8|
utf16_czech_ci |utf16 | 111| |Yes | 8|
utf16_danish_ci |utf16 | 112| |Yes | 8|
utf16_lithuanian_ci |utf16 | 113| |Yes | 8|
utf16_slovak_ci |utf16 | 114| |Yes | 8|
utf16_spanish2_ci |utf16 | 115| |Yes | 8|
utf16_roman_ci |utf16 | 116| |Yes | 8|
utf16_persian_ci |utf16 | 117| |Yes | 8|
utf16_esperanto_ci |utf16 | 118| |Yes | 8|
utf16_hungarian_ci |utf16 | 119| |Yes | 8|
utf16_sinhala_ci |utf16 | 120| |Yes | 8|
utf16_german2_ci |utf16 | 121| |Yes | 8|
utf16_croatian_mysql561_ci |utf16 | 122| |Yes | 8|
utf16_unicode_520_ci |utf16 | 123| |Yes | 8|
utf16_vietnamese_ci |utf16 | 124| |Yes | 8|
utf16_croatian_ci |utf16 | 672| |Yes | 8|
utf16_myanmar_ci |utf16 | 673| |Yes | 8|
utf16_thai_520_w2 |utf16 | 674| |Yes | 4|
utf16_general_nopad_ci |utf16 |1078| |Yes | 1|
utf16_nopad_bin |utf16 |1079| |Yes | 1|
utf16_unicode_nopad_ci |utf16 |1125| |Yes | 8|
utf16_unicode_520_nopad_ci |utf16 |1147| |Yes | 8|
utf16le_general_ci |utf16le | 56|Yes |Yes | 1|
utf16le_bin |utf16le | 62| |Yes | 1|
utf16le_general_nopad_ci |utf16le |1080| |Yes | 1|
utf16le_nopad_bin |utf16le |1086| |Yes | 1|
cp1256_general_ci |cp1256 | 57|Yes |Yes | 1|
cp1256_bin |cp1256 | 67| |Yes | 1|
cp1256_general_nopad_ci |cp1256 |1081| |Yes | 1|
cp1256_nopad_bin |cp1256 |1091| |Yes | 1|
cp1257_lithuanian_ci |cp1257 | 29| |Yes | 1|
cp1257_bin |cp1257 | 58| |Yes | 1|
cp1257_general_ci |cp1257 | 59|Yes |Yes | 1|
cp1257_nopad_bin |cp1257 |1082| |Yes | 1|
cp1257_general_nopad_ci |cp1257 |1083| |Yes | 1|
utf32_general_ci |utf32 | 60|Yes |Yes | 1|
utf32_bin |utf32 | 61| |Yes | 1|
utf32_unicode_ci |utf32 | 160| |Yes | 8|
utf32_icelandic_ci |utf32 | 161| |Yes | 8|
utf32_latvian_ci |utf32 | 162| |Yes | 8|
utf32_romanian_ci |utf32 | 163| |Yes | 8|
utf32_slovenian_ci |utf32 | 164| |Yes | 8|
utf32_polish_ci |utf32 | 165| |Yes | 8|
utf32_estonian_ci |utf32 | 166| |Yes | 8|
utf32_spanish_ci |utf32 | 167| |Yes | 8|
utf32_swedish_ci |utf32 | 168| |Yes | 8|
utf32_turkish_ci |utf32 | 169| |Yes | 8|
utf32_czech_ci |utf32 | 170| |Yes | 8|
utf32_danish_ci |utf32 | 171| |Yes | 8|
utf32_lithuanian_ci |utf32 | 172| |Yes | 8|
utf32_slovak_ci |utf32 | 173| |Yes | 8|
utf32_spanish2_ci |utf32 | 174| |Yes | 8|
utf32_roman_ci |utf32 | 175| |Yes | 8|
utf32_persian_ci |utf32 | 176| |Yes | 8|
utf32_esperanto_ci |utf32 | 177| |Yes | 8|
utf32_hungarian_ci |utf32 | 178| |Yes | 8|
utf32_sinhala_ci |utf32 | 179| |Yes | 8|
utf32_german2_ci |utf32 | 180| |Yes | 8|
utf32_croatian_mysql561_ci |utf32 | 181| |Yes | 8|
utf32_unicode_520_ci |utf32 | 182| |Yes | 8|
utf32_vietnamese_ci |utf32 | 183| |Yes | 8|
utf32_croatian_ci |utf32 | 736| |Yes | 8|
utf32_myanmar_ci |utf32 | 737| |Yes | 8|
utf32_thai_520_w2 |utf32 | 738| |Yes | 4|
utf32_general_nopad_ci |utf32 |1084| |Yes | 1|
utf32_nopad_bin |utf32 |1085| |Yes | 1|
utf32_unicode_nopad_ci |utf32 |1184| |Yes | 8|
utf32_unicode_520_nopad_ci |utf32 |1206| |Yes | 8|
binary |binary | 63|Yes |Yes | 1|
geostd8_general_ci |geostd8 | 92|Yes |Yes | 1|
geostd8_bin |geostd8 | 93| |Yes | 1|
geostd8_general_nopad_ci |geostd8 |1116| |Yes | 1|
geostd8_nopad_bin |geostd8 |1117| |Yes | 1|
cp932_japanese_ci |cp932 | 95|Yes |Yes | 1|
cp932_bin |cp932 | 96| |Yes | 1|
cp932_japanese_nopad_ci |cp932 |1119| |Yes | 1|
cp932_nopad_bin |cp932 |1120| |Yes | 1|
eucjpms_japanese_ci |eucjpms | 97|Yes |Yes | 1|
eucjpms_bin |eucjpms | 98| |Yes | 1|
eucjpms_japanese_nopad_ci |eucjpms |1121| |Yes | 1|
eucjpms_nopad_bin |eucjpms |1122| |Yes | 1|