From the query select coll.ID, coll.COLLATION_NAME, cs.MAXLEN from information_schema.collations coll inner join information_schema.character_sets cs using(CHARACTER_SET_NAME) order by coll.ID; on MariaDB 10.2.8.
| ID |
Collation |
Max Length |
| 576 |
utf8_croatian_ci |
3 |
| 577 |
utf8_myanmar_ci |
3 |
| 578 |
utf8_thai_520_w2 |
3 |
| 608 |
utf8mb4_croatian_ci |
4 |
| 609 |
utf8mb4_myanmar_ci |
4 |
| 610 |
utf8mb4_thai_520_w2 |
4 |
| 640 |
ucs2_croatian_ci |
2 |
| 641 |
ucs2_myanmar_ci |
2 |
| 642 |
ucs2_thai_520_w2 |
2 |
| 672 |
utf16_croatian_ci |
4 |
| 673 |
utf16_myanmar_ci |
4 |
| 674 |
utf16_thai_520_w2 |
4 |
| 736 |
utf32_croatian_ci |
4 |
| 737 |
utf32_myanmar_ci |
4 |
| 738 |
utf32_thai_520_w2 |
4 |
| 1025 |
big5_chinese_nopad_ci |
2 |
| 1027 |
dec8_swedish_nopad_ci |
1 |
| 1028 |
cp850_general_nopad_ci |
1 |
| 1030 |
hp8_english_nopad_ci |
1 |
| 1031 |
koi8r_general_nopad_ci |
1 |
| 1032 |
latin1_swedish_nopad_ci |
1 |
| 1033 |
latin2_general_nopad_ci |
1 |
| 1034 |
swe7_swedish_nopad_ci |
1 |
| 1035 |
ascii_general_nopad_ci |
1 |
| 1036 |
ujis_japanese_nopad_ci |
3 |
| 1037 |
sjis_japanese_nopad_ci |
2 |
| 1040 |
hebrew_general_nopad_ci |
1 |
| 1042 |
tis620_thai_nopad_ci |
1 |
| 1043 |
euckr_korean_nopad_ci |
2 |
| 1046 |
koi8u_general_nopad_ci |
1 |
| 1048 |
gb2312_chinese_nopad_ci |
2 |
| 1049 |
greek_general_nopad_ci |
1 |
| 1050 |
cp1250_general_nopad_ci |
1 |
| 1052 |
gbk_chinese_nopad_ci |
2 |
| 1054 |
latin5_turkish_nopad_ci |
1 |
| 1056 |
armscii8_general_nopad_ci |
1 |
| 1057 |
utf8_general_nopad_ci |
3 |
| 1059 |
ucs2_general_nopad_ci |
2 |
| 1060 |
cp866_general_nopad_ci |
1 |
| 1061 |
keybcs2_general_nopad_ci |
1 |
| 1062 |
macce_general_nopad_ci |
1 |
| 1063 |
macroman_general_nopad_ci |
1 |
| 1064 |
cp852_general_nopad_ci |
1 |
| 1065 |
latin7_general_nopad_ci |
1 |
| 1067 |
macce_nopad_bin |
1 |
| 1069 |
utf8mb4_general_nopad_ci |
4 |
| 1070 |
utf8mb4_nopad_bin |
4 |
| 1071 |
latin1_nopad_bin |
1 |
| 1074 |
cp1251_nopad_bin |
1 |
| 1075 |
cp1251_general_nopad_ci |
1 |
| 1077 |
macroman_nopad_bin |
1 |
| 1078 |
utf16_general_nopad_ci |
4 |
| 1079 |
utf16_nopad_bin |
4 |
| 1080 |
utf16le_general_nopad_ci |
4 |
| 1081 |
cp1256_general_nopad_ci |
1 |
| 1082 |
cp1257_nopad_bin |
1 |
| 1083 |
cp1257_general_nopad_ci |
1 |
| 1084 |
utf32_general_nopad_ci |
4 |
| 1085 |
utf32_nopad_bin |
4 |
| 1086 |
utf16le_nopad_bin |
4 |
| 1088 |
armscii8_nopad_bin |
1 |
| 1089 |
ascii_nopad_bin |
1 |
| 1090 |
cp1250_nopad_bin |
1 |
| 1091 |
cp1256_nopad_bin |
1 |
| 1092 |
cp866_nopad_bin |
1 |
| 1093 |
dec8_nopad_bin |
1 |
| 1094 |
greek_nopad_bin |
1 |
| 1095 |
hebrew_nopad_bin |
1 |
| 1096 |
hp8_nopad_bin |
1 |
| 1097 |
keybcs2_nopad_bin |
1 |
| 1098 |
koi8r_nopad_bin |
1 |
| 1099 |
koi8u_nopad_bin |
1 |
| 1101 |
latin2_nopad_bin |
1 |
| 1102 |
latin5_nopad_bin |
1 |
| 1103 |
latin7_nopad_bin |
1 |
| 1104 |
cp850_nopad_bin |
1 |
| 1105 |
cp852_nopad_bin |
1 |
| 1106 |
swe7_nopad_bin |
1 |
| 1107 |
utf8_nopad_bin |
3 |
| 1108 |
big5_nopad_bin |
2 |
| 1109 |
euckr_nopad_bin |
2 |
| 1110 |
gb2312_nopad_bin |
2 |
| 1111 |
gbk_nopad_bin |
2 |
| 1112 |
sjis_nopad_bin |
2 |
| 1113 |
tis620_nopad_bin |
1 |
| 1114 |
ucs2_nopad_bin |
2 |
| 1115 |
ujis_nopad_bin |
3 |
| 1116 |
geostd8_general_nopad_ci |
1 |
| 1117 |
geostd8_nopad_bin |
1 |
| 1119 |
cp932_japanese_nopad_ci |
2 |
| 1120 |
cp932_nopad_bin |
2 |
| 1121 |
eucjpms_japanese_nopad_ci |
3 |
| 1122 |
eucjpms_nopad_bin |
3 |
| 1125 |
utf16_unicode_nopad_ci |
4 |
| 1147 |
utf16_unicode_520_nopad_ci |
4 |
| 1152 |
ucs2_unicode_nopad_ci |
2 |
| 1174 |
ucs2_unicode_520_nopad_ci |
2 |
| 1184 |
utf32_unicode_nopad_ci |
4 |
| 1206 |
utf32_unicode_520_nopad_ci |
4 |
| 1216 |
utf8_unicode_nopad_ci |
3 |
| 1238 |
utf8_unicode_520_nopad_ci |
3 |
| 1248 |
utf8mb4_unicode_nopad_ci |
4 |
| 1270 |
utf8mb4_unicode_520_nopad_ci |
4 |
From the query
select coll.ID, coll.COLLATION_NAME, cs.MAXLEN from information_schema.collations coll inner join information_schema.character_sets cs using(CHARACTER_SET_NAME) order by coll.ID;on MariaDB 10.2.8.