Supported Character Sets and Collations

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:

CharsetDescriptionDefault collationMaxlen
armscii8ARMSCII-8 Armenianarmscii8_general_ci1
asciiUS ASCIIascii_general_ci1
big5Big5 Traditional Chinesebig5_chinese_ci2
binaryBinary pseudo charsetbinary1
cp1250Windows Central Europeancp1250_general_ci1
cp1251Windows Cyrilliccp1251_general_ci1
cp1256Windows Arabiccp1256_general_ci1
cp1257Windows Balticcp1257_general_ci1
cp850DOS West Europeancp850_general_ci1
cp852DOS Central Europeancp852_general_ci1
cp866DOS Russiancp866_general_ci1
cp932SJIS for Windows Japanesecp932_japanese_ci2
dec8DEC West Europeandec8_swedish_ci1
eucjpmsUJIS for Windows Japaneseeucjpms_japanese_ci3
euckrEUC-KR Koreaneuckr_korean_ci2
gb2312GB2312 Simplified Chinesegb2312_chinese_ci2
gbkGBK Simplified Chinesegbk_chinese_ci2
geostd8GEOSTD8 Georgiangeostd8_general_ci1
greekISO 8859-7 Greekgreek_general_ci1
hebrewISO 8859-8 Hebrewhebrew_general_ci1
hp8HP West Europeanhp8_english_ci1
keybcs2DOS Kamenicky Czech-Slovakkeybcs2_general_ci1
koi8rKOI8-R Relcom Russiankoi8r_general_ci1
koi8uKOI8-U Ukrainiankoi8u_general_ci1
latin1cp1252 West Europeanlatin1_swedish_ci1
latin2ISO 8859-2 Central Europeanlatin2_general_ci1
latin5ISO 8859-9 Turkishlatin5_turkish_ci1
latin7ISO 8859-13 Balticlatin7_general_ci1
macceMac Central Europeanmacce_general_ci1
macromanMac West Europeanmacroman_general_ci1
sjisShift-JIS Japanesesjis_japanese_ci2
swe77bit Swedishswe7_swedish_ci1
tis620TIS620 Thaitis620_thai_ci1
ucs2UCS-2 Unicodeucs2_general_ci2
ujisEUC-JP Japaneseujis_japanese_ci3
utf8UTF-8 Unicodeutf8_general_ci3/4 (see OLD_MODE)
utf16UTF-16 Unicodeutf16_general_ci4
utf16leUTF-16LE Unicodeutf16le_general_ci4
utf32UTF-32 Unicodeutf32_general_ci4
utf8mb3UTF-8 Unicodeutf8mb3_general_ci3
utf8mb4UTF-8 Unicodeutf8mb4_general_ci4

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     | 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 |
| 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     | 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 |
+--------------------------------+----------+------+---------+----------+---------+
506 rows in set (0.002 sec)

This is from MariaDB 10.11.5 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*.

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 utf8 character set by default to be an alias for utf8mb3 rather than the other way around. It can be set to imply utf8mb4 by changing the value of the old_mode system variable.
  • MariaDB 10.2.2 added 88 NO PAD collations.
  • MariaDB 10.1.15 added the utf8_thai_520_w2, utf8mb4_thai_520_w2, ucs2_thai_520_w2, utf16_thai_520_w2 and utf32_thai_520_w2 collations.
  • MariaDB 10.0.7 added the utf8_myanmar_ci, ucs2_myanmar_ci, utf8mb4_myanmar_ci, utf16_myanmar_ci and utf32_myanmar_ci collations.
  • MariaDB 10.0.5 added the utf8_german2_ci, utf8mb4_german2_ci, ucs2_german2_ci, utf16_german2_ci and utf32_german2_ci collations.
  • MariaDB 5.1.41 added a Croatian collation patch from Alexander Barkov to fix some problems with the Croatian character set and LIKE queries. This patch added utf8_croatian_ci and ucs2_croatian_ci collations to MariaDB.

See Also

Comments

Comments loading...
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.