Supported Character Sets and Collations
Contents
Character Sets
You can see which character sets are available in a particular version by running the SHOW CHARACTER SET statement or by querying the Information Schema CHARACTER_SETS Table.
From MariaDB 11.2, it is possible to change the default collation associated with a character set. See Changing Default Collation
MariaDB supports the following character sets:
| Charset | Description | Default collation | Maxlen |
|---|---|---|---|
| armscii8 | ARMSCII-8 Armenian | armscii8_general_ci | 1 |
| ascii | US ASCII | ascii_general_ci | 1 |
| big5 | Big5 Traditional Chinese | big5_chinese_ci | 2 |
| binary | Binary pseudo charset | binary | 1 |
| cp1250 | Windows Central European | cp1250_general_ci | 1 |
| cp1251 | Windows Cyrillic | cp1251_general_ci | 1 |
| cp1256 | Windows Arabic | cp1256_general_ci | 1 |
| cp1257 | Windows Baltic | cp1257_general_ci | 1 |
| cp850 | DOS West European | cp850_general_ci | 1 |
| cp852 | DOS Central European | cp852_general_ci | 1 |
| cp866 | DOS Russian | cp866_general_ci | 1 |
| cp932 | SJIS for Windows Japanese | cp932_japanese_ci | 2 |
| dec8 | DEC West European | dec8_swedish_ci | 1 |
| eucjpms | UJIS for Windows Japanese | eucjpms_japanese_ci | 3 |
| euckr | EUC-KR Korean | euckr_korean_ci | 2 |
| gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2 |
| gbk | GBK Simplified Chinese | gbk_chinese_ci | 2 |
| geostd8 | GEOSTD8 Georgian | geostd8_general_ci | 1 |
| greek | ISO 8859-7 Greek | greek_general_ci | 1 |
| hebrew | ISO 8859-8 Hebrew | hebrew_general_ci | 1 |
| hp8 | HP West European | hp8_english_ci | 1 |
| keybcs2 | DOS Kamenicky Czech-Slovak | keybcs2_general_ci | 1 |
| koi8r | KOI8-R Relcom Russian | koi8r_general_ci | 1 |
| koi8u | KOI8-U Ukrainian | koi8u_general_ci | 1 |
| latin1 | cp1252 West European | latin1_swedish_ci | 1 |
| latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 |
| latin5 | ISO 8859-9 Turkish | latin5_turkish_ci | 1 |
| latin7 | ISO 8859-13 Baltic | latin7_general_ci | 1 |
| macce | Mac Central European | macce_general_ci | 1 |
| macroman | Mac West European | macroman_general_ci | 1 |
| sjis | Shift-JIS Japanese | sjis_japanese_ci | 2 |
| swe7 | 7bit Swedish | swe7_swedish_ci | 1 |
| tis620 | TIS620 Thai | tis620_thai_ci | 1 |
| ucs2 | UCS-2 Unicode | ucs2_general_ci | 2 |
| ujis | EUC-JP Japanese | ujis_japanese_ci | 3 |
| utf8 | UTF-8 Unicode | utf8_general_ci | 3/4 (see OLD_MODE) |
| utf16 | UTF-16 Unicode | utf16_general_ci | 4 |
| utf16le | UTF-16LE Unicode | utf16le_general_ci | 4 |
| utf32 | UTF-32 Unicode | utf32_general_ci | 4 |
| utf8mb3 | UTF-8 Unicode | utf8mb3_general_ci | 3 |
| utf8mb4 | UTF-8 Unicode | utf8mb4_general_ci | 4 |
Note that the Mroonga Storage Engine only supports a limited number of character sets. See Mroonga available character sets.
Collations
MariaDB supports the following collations:
show collation; +--------------------------------+----------+------+---------+----------+---------+ | 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 | 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_general1400_as_ci | utf8mb3 | 579 | | Yes | 1 | | 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 | 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 | 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_general1400_as_ci | utf8mb4 | 611 | | Yes | 1 | | 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 | | uca1400_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_icelandic_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_icelandic_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_icelandic_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_icelandic_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_icelandic_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_icelandic_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_icelandic_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_icelandic_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_latvian_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_latvian_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_latvian_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_latvian_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_latvian_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_latvian_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_latvian_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_latvian_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_romanian_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_romanian_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_romanian_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_romanian_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_romanian_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_romanian_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_romanian_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_romanian_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_slovenian_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_slovenian_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_slovenian_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_slovenian_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_slovenian_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_slovenian_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_slovenian_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_slovenian_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_polish_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_polish_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_polish_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_polish_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_polish_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_polish_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_polish_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_polish_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_estonian_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_estonian_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_estonian_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_estonian_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_estonian_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_estonian_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_estonian_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_estonian_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_swedish_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_swedish_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_swedish_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_swedish_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_swedish_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_swedish_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_swedish_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_swedish_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_turkish_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_turkish_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_turkish_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_turkish_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_turkish_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_turkish_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_turkish_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_turkish_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_czech_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_czech_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_czech_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_czech_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_czech_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_czech_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_czech_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_czech_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_danish_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_danish_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_danish_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_danish_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_danish_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_danish_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_danish_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_danish_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_lithuanian_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_lithuanian_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_lithuanian_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_lithuanian_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_lithuanian_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_lithuanian_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_lithuanian_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_lithuanian_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_slovak_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_slovak_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_slovak_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_slovak_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_slovak_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_slovak_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_slovak_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_slovak_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish2_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish2_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish2_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish2_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish2_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish2_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish2_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_spanish2_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_roman_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_roman_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_roman_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_roman_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_roman_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_roman_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_roman_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_roman_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_persian_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_persian_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_persian_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_persian_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_persian_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_persian_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_persian_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_persian_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_esperanto_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_esperanto_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_esperanto_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_esperanto_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_esperanto_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_esperanto_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_esperanto_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_esperanto_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_hungarian_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_hungarian_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_hungarian_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_hungarian_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_hungarian_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_hungarian_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_hungarian_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_hungarian_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_sinhala_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_sinhala_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_sinhala_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_sinhala_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_sinhala_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_sinhala_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_sinhala_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_sinhala_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_german2_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_german2_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_german2_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_german2_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_german2_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_german2_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_german2_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_german2_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_vietnamese_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_vietnamese_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_vietnamese_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_vietnamese_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_vietnamese_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_vietnamese_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_vietnamese_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_vietnamese_nopad_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_croatian_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_croatian_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_croatian_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_croatian_as_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_croatian_nopad_ai_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_croatian_nopad_ai_cs | NULL | NULL | NULL | Yes | 8 | | uca1400_croatian_nopad_as_ci | NULL | NULL | NULL | Yes | 8 | | uca1400_croatian_nopad_as_cs | NULL | NULL | NULL | 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 | 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 | 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 | +--------------------------------+----------+------+---------+----------+---------+ 508 rows in set (0.003 sec)
This is from MariaDB 11.5.1 including the UCA-14.0.0 collations added in MariaDB 10.10.1.
Before MariaDB 10.6.1, the utf8mb3* collations listed above were named utf8*.
Note that some of the collations are used with several different character sets. In this case the Charset and Id columns are NULL.
You can find all combinations of supported character set and collation in the information_schema.COLLATION_CHARACTER_SET_APPLICABILITY table.
Case Sensitivity
A 'ci' at the end of a collation name indicates the
collation is case insensitive. A 'cs' at the end of a
collation name indicates the collation is case sensitive.
NO PAD Collations
NO PAD collations regard trailing spaces as normal characters. You can get a list of all of these by querying the Information Schema COLLATIONS Table as follows:
SELECT collation_name FROM information_schema.COLLATIONS WHERE collation_name LIKE "%nopad%"; +------------------------------+ | collation_name | +------------------------------+ | big5_chinese_nopad_ci | | big5_nopad_bin | ...
Accent Insensitivity
An accent insensitive collation is one where the accented and unaccented versions of a letter are considered to be identical for sorting purposes.
MariaDB 10.10 added the accent insensitivity flag, and new collations are marked with '_ai' or '_as' in the name to indicate this, for example:
... | uca1400_spanish2_ai_ci | | uca1400_spanish2_ai_cs | | uca1400_spanish2_as_ci | | uca1400_spanish2_as_cs | ...
Changes
- MariaDB 10.10 added 184 UCA-14.0.0 collations. Unicode-14.0.0 was released in September 2021. They contain 939 built-in contractions. Old collations based on UCA-4.0.0 and UCA-5.2.0 did not support built-in contractions. This is a step towards better Unicode Collation Algorithm compliance. With built-in contractions, some languages (e.g. Thai) won't need specific collations and will just work with the default "root" collation.
- MariaDB 10.6.1 changed the
utf8character set by default to be an alias for utf8mb3 rather than the other way around. It can be set to implyutf8mb4by changing the value of the old_mode system variable. - MariaDB 10.2.2 added 88
NO PADcollations. - MariaDB 10.1.15 added the
utf8_thai_520_w2,utf8mb4_thai_520_w2,ucs2_thai_520_w2,utf16_thai_520_w2andutf32_thai_520_w2collations. - MariaDB 10.0.7 added the
utf8_myanmar_ci,ucs2_myanmar_ci,utf8mb4_myanmar_ci,utf16_myanmar_ciandutf32_myanmar_cicollations. - MariaDB 10.0.5 added the
utf8_german2_ci,utf8mb4_german2_ci,ucs2_german2_ci,utf16_german2_ciandutf32_german2_cicollations. - MariaDB 5.1.41 added a Croatian collation patch from
Alexander Barkov to fix some problems with the
Croatian character set and
LIKEqueries. This patch addedutf8_croatian_cianducs2_croatian_cicollations to MariaDB.
See Also
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
