Collations for MariaDB Community Server 10.6

This page is part of MariaDB's MariaDB Documentation.

The parent of this page is: Reference for MariaDB Community Server 10.6

Topics on this page:

Overview
Collations for MariaDB Community Server 10.6

Overview

MariaDB Community Server supports many different collations.

Reference material is available for MariaDB Community Server 10.6.

Collations for MariaDB Community Server 10.6

The following collations are supported by MariaDB Community Server 10.6:

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

To see collations supported in other versions, see "Collations by MariaDB Server Version".