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 (<= MariaDB 11.4) <br>ucs2_uca1400_ai_ci (>=MariaDB 11.5) | 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 (<= MariaDB 11.4)<br>utf16_uca1400_ai_ci (>=MariaDB 11.5) | 4 |
| utf16le | UTF-16LE Unicode | utf16le_general_ci | 4 |
| utf32 | UTF-32 Unicode | utf32_general_ci (<= MariaDB 11.4) utf32_uca1400_ai_ci (>=MariaDB 11.5) | 4 |
| utf8mb3 | UTF-8 Unicode | utf8mb3_general_ci (<= MariaDB 11.4) utf8mb3_uca1400_ai_ci (>=MariaDB 11.5) | 3 |
| utf8mb4 | UTF-8 Unicode | utf8mb4_general_ci (<= MariaDB 11.4) utf8mb4_uca1400_ai_ci (>=MariaDB 11.5) | 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 (from MariaDB 11.4.5):
SELECT collation_name, character_set_name as cs_name, id, is_default AS def, is_compiled AS com, sortlen, comment FROM information_schema.collations ORDER BY collation_name; +--------------------------------+----------+------+------+-----+---------+--------------------------------------------------+ | collation_name | cs_name | id | def | com | sortlen | comment | +--------------------------------+----------+------+------+-----+---------+--------------------------------------------------+ | armscii8_bin | armscii8 | 64 | | Yes | 1 | ARMSCII-8 Armenian | | armscii8_general_ci | armscii8 | 32 | Yes | Yes | 1 | ARMSCII-8 Armenian | | armscii8_general_nopad_ci | armscii8 | 1056 | | Yes | 1 | ARMSCII-8 Armenian | | armscii8_nopad_bin | armscii8 | 1088 | | Yes | 1 | ARMSCII-8 Armenian | | ascii_bin | ascii | 65 | | Yes | 1 | US ASCII | | ascii_general_ci | ascii | 11 | Yes | Yes | 1 | US ASCII | | ascii_general_nopad_ci | ascii | 1035 | | Yes | 1 | US ASCII | | ascii_nopad_bin | ascii | 1089 | | Yes | 1 | US ASCII | | big5_bin | big5 | 84 | | Yes | 1 | Big5 Traditional Chinese | | big5_chinese_ci | big5 | 1 | Yes | Yes | 1 | Big5 Traditional Chinese | | big5_chinese_nopad_ci | big5 | 1025 | | Yes | 1 | | | big5_nopad_bin | big5 | 1108 | | Yes | 1 | | | binary | binary | 63 | Yes | Yes | 1 | Binary pseudo charset | | cp1250_bin | cp1250 | 66 | | Yes | 1 | Windows Central European | | cp1250_croatian_ci | cp1250 | 44 | | Yes | 1 | Windows Central European | | cp1250_czech_cs | cp1250 | 34 | | Yes | 2 | Windows Central European | | cp1250_general_ci | cp1250 | 26 | Yes | Yes | 1 | Windows Central European | | cp1250_general_nopad_ci | cp1250 | 1050 | | Yes | 1 | Windows Central European | | cp1250_nopad_bin | cp1250 | 1090 | | Yes | 1 | Windows Central European | | cp1250_polish_ci | cp1250 | 99 | | Yes | 1 | Windows Central European | | cp1251_bin | cp1251 | 50 | | Yes | 1 | Windows Cyrillic | | cp1251_bulgarian_ci | cp1251 | 14 | | Yes | 1 | Windows Cyrillic | | cp1251_general_ci | cp1251 | 51 | Yes | Yes | 1 | Windows Cyrillic | | cp1251_general_cs | cp1251 | 52 | | Yes | 1 | Windows Cyrillic | | cp1251_general_nopad_ci | cp1251 | 1075 | | Yes | 1 | Windows Cyrillic | | cp1251_nopad_bin | cp1251 | 1074 | | Yes | 1 | Windows Cyrillic | | cp1251_ukrainian_ci | cp1251 | 23 | | Yes | 1 | Windows Cyrillic | | cp1256_bin | cp1256 | 67 | | Yes | 1 | Windows Arabic | | cp1256_general_ci | cp1256 | 57 | Yes | Yes | 1 | Windows Arabic | | cp1256_general_nopad_ci | cp1256 | 1081 | | Yes | 1 | Windows Arabic | | cp1256_nopad_bin | cp1256 | 1091 | | Yes | 1 | Windows Arabic | | cp1257_bin | cp1257 | 58 | | Yes | 1 | Windows Baltic | | cp1257_general_ci | cp1257 | 59 | Yes | Yes | 1 | Windows Baltic | | cp1257_general_nopad_ci | cp1257 | 1083 | | Yes | 1 | Windows Baltic | | cp1257_lithuanian_ci | cp1257 | 29 | | Yes | 1 | Windows Baltic | | cp1257_nopad_bin | cp1257 | 1082 | | Yes | 1 | Windows Baltic | | cp850_bin | cp850 | 80 | | Yes | 1 | DOS West European | | cp850_general_ci | cp850 | 4 | Yes | Yes | 1 | DOS West European | | cp850_general_nopad_ci | cp850 | 1028 | | Yes | 1 | DOS West European | | cp850_nopad_bin | cp850 | 1104 | | Yes | 1 | DOS West European | | cp852_bin | cp852 | 81 | | Yes | 1 | DOS Central European | | cp852_general_ci | cp852 | 40 | Yes | Yes | 1 | DOS Central European | | cp852_general_nopad_ci | cp852 | 1064 | | Yes | 1 | DOS Central European | | cp852_nopad_bin | cp852 | 1105 | | Yes | 1 | DOS Central European | | cp866_bin | cp866 | 68 | | Yes | 1 | DOS Russian | | cp866_general_ci | cp866 | 36 | Yes | Yes | 1 | DOS Russian | | cp866_general_nopad_ci | cp866 | 1060 | | Yes | 1 | DOS Russian | | cp866_nopad_bin | cp866 | 1092 | | Yes | 1 | DOS Russian | | cp932_bin | cp932 | 96 | | Yes | 1 | SJIS for Windows Japanese | | cp932_japanese_ci | cp932 | 95 | Yes | Yes | 1 | SJIS for Windows Japanese | | cp932_japanese_nopad_ci | cp932 | 1119 | | Yes | 1 | | | cp932_nopad_bin | cp932 | 1120 | | Yes | 1 | | | dec8_bin | dec8 | 69 | | Yes | 1 | DEC West European | | dec8_nopad_bin | dec8 | 1093 | | Yes | 1 | DEC West European | | dec8_swedish_ci | dec8 | 3 | Yes | Yes | 1 | DEC West European | | dec8_swedish_nopad_ci | dec8 | 1027 | | Yes | 1 | DEC West European | | eucjpms_bin | eucjpms | 98 | | Yes | 1 | UJIS for Windows Japanese | | eucjpms_japanese_ci | eucjpms | 97 | Yes | Yes | 1 | UJIS for Windows Japanese | | eucjpms_japanese_nopad_ci | eucjpms | 1121 | | Yes | 1 | | | eucjpms_nopad_bin | eucjpms | 1122 | | Yes | 1 | | | euckr_bin | euckr | 85 | | Yes | 1 | EUC-KR Korean | | euckr_korean_ci | euckr | 19 | Yes | Yes | 1 | EUC-KR Korean | | euckr_korean_nopad_ci | euckr | 1043 | | Yes | 1 | | | euckr_nopad_bin | euckr | 1109 | | Yes | 1 | | | gb2312_bin | gb2312 | 86 | | Yes | 1 | GB2312 Simplified Chinese | | gb2312_chinese_ci | gb2312 | 24 | Yes | Yes | 1 | GB2312 Simplified Chinese | | gb2312_chinese_nopad_ci | gb2312 | 1048 | | Yes | 1 | | | gb2312_nopad_bin | gb2312 | 1110 | | Yes | 1 | | | gbk_bin | gbk | 87 | | Yes | 1 | GBK Simplified Chinese | | gbk_chinese_ci | gbk | 28 | Yes | Yes | 1 | GBK Simplified Chinese | | gbk_chinese_nopad_ci | gbk | 1052 | | Yes | 1 | | | gbk_nopad_bin | gbk | 1111 | | Yes | 1 | | | geostd8_bin | geostd8 | 93 | | Yes | 1 | GEOSTD8 Georgian | | geostd8_general_ci | geostd8 | 92 | Yes | Yes | 1 | GEOSTD8 Georgian | | geostd8_general_nopad_ci | geostd8 | 1116 | | Yes | 1 | GEOSTD8 Georgian | | geostd8_nopad_bin | geostd8 | 1117 | | Yes | 1 | GEOSTD8 Georgian | | greek_bin | greek | 70 | | Yes | 1 | ISO 8859-7 Greek | | greek_general_ci | greek | 25 | Yes | Yes | 1 | ISO 8859-7 Greek | | greek_general_nopad_ci | greek | 1049 | | Yes | 1 | ISO 8859-7 Greek | | greek_nopad_bin | greek | 1094 | | Yes | 1 | ISO 8859-7 Greek | | hebrew_bin | hebrew | 71 | | Yes | 1 | ISO 8859-8 Hebrew | | hebrew_general_ci | hebrew | 16 | Yes | Yes | 1 | ISO 8859-8 Hebrew | | hebrew_general_nopad_ci | hebrew | 1040 | | Yes | 1 | ISO 8859-8 Hebrew | | hebrew_nopad_bin | hebrew | 1095 | | Yes | 1 | ISO 8859-8 Hebrew | | hp8_bin | hp8 | 72 | | Yes | 1 | HP West European | | hp8_english_ci | hp8 | 6 | Yes | Yes | 1 | HP West European | | hp8_english_nopad_ci | hp8 | 1030 | | Yes | 1 | HP West European | | hp8_nopad_bin | hp8 | 1096 | | Yes | 1 | HP West European | | keybcs2_bin | keybcs2 | 73 | | Yes | 1 | DOS Kamenicky Czech-Slovak | | keybcs2_general_ci | keybcs2 | 37 | Yes | Yes | 1 | DOS Kamenicky Czech-Slovak | | keybcs2_general_nopad_ci | keybcs2 | 1061 | | Yes | 1 | DOS Kamenicky Czech-Slovak | | keybcs2_nopad_bin | keybcs2 | 1097 | | Yes | 1 | DOS Kamenicky Czech-Slovak | | koi8r_bin | koi8r | 74 | | Yes | 1 | KOI8-R Relcom Russian | | koi8r_general_ci | koi8r | 7 | Yes | Yes | 1 | KOI8-R Relcom Russian | | koi8r_general_nopad_ci | koi8r | 1031 | | Yes | 1 | KOI8-R Relcom Russian | | koi8r_nopad_bin | koi8r | 1098 | | Yes | 1 | KOI8-R Relcom Russian | | koi8u_bin | koi8u | 75 | | Yes | 1 | KOI8-U Ukrainian | | koi8u_general_ci | koi8u | 22 | Yes | Yes | 1 | KOI8-U Ukrainian | | koi8u_general_nopad_ci | koi8u | 1046 | | Yes | 1 | KOI8-U Ukrainian | | koi8u_nopad_bin | koi8u | 1099 | | Yes | 1 | KOI8-U Ukrainian | | latin1_bin | latin1 | 47 | | Yes | 1 | cp1252 West European | | latin1_danish_ci | latin1 | 15 | | Yes | 1 | cp1252 West European | | latin1_general_ci | latin1 | 48 | | Yes | 1 | cp1252 West European | | latin1_general_cs | latin1 | 49 | | Yes | 1 | cp1252 West European | | latin1_german1_ci | latin1 | 5 | | Yes | 1 | cp1252 West European | | latin1_german2_ci | latin1 | 31 | | Yes | 2 | cp1252 West European | | latin1_nopad_bin | latin1 | 1071 | | Yes | 1 | | | latin1_spanish_ci | latin1 | 94 | | Yes | 1 | cp1252 West European | | latin1_swedish_ci | latin1 | 8 | Yes | Yes | 1 | cp1252 West European | | latin1_swedish_nopad_ci | latin1 | 1032 | | Yes | 1 | | | latin2_bin | latin2 | 77 | | Yes | 1 | ISO 8859-2 Central European | | latin2_croatian_ci | latin2 | 27 | | Yes | 1 | ISO 8859-2 Central European | | latin2_czech_cs | latin2 | 2 | | Yes | 4 | ISO 8859-2 Central European | | latin2_general_ci | latin2 | 9 | Yes | Yes | 1 | ISO 8859-2 Central European | | latin2_general_nopad_ci | latin2 | 1033 | | Yes | 1 | ISO 8859-2 Central European | | latin2_hungarian_ci | latin2 | 21 | | Yes | 1 | ISO 8859-2 Central European | | latin2_nopad_bin | latin2 | 1101 | | Yes | 1 | ISO 8859-2 Central European | | latin5_bin | latin5 | 78 | | Yes | 1 | ISO 8859-9 Turkish | | latin5_nopad_bin | latin5 | 1102 | | Yes | 1 | ISO 8859-9 Turkish | | latin5_turkish_ci | latin5 | 30 | Yes | Yes | 1 | ISO 8859-9 Turkish | | latin5_turkish_nopad_ci | latin5 | 1054 | | Yes | 1 | ISO 8859-9 Turkish | | latin7_bin | latin7 | 79 | | Yes | 1 | ISO 8859-13 Baltic | | latin7_estonian_cs | latin7 | 20 | | Yes | 1 | ISO 8859-13 Baltic | | latin7_general_ci | latin7 | 41 | Yes | Yes | 1 | ISO 8859-13 Baltic | | latin7_general_cs | latin7 | 42 | | Yes | 1 | ISO 8859-13 Baltic | | latin7_general_nopad_ci | latin7 | 1065 | | Yes | 1 | ISO 8859-13 Baltic | | latin7_nopad_bin | latin7 | 1103 | | Yes | 1 | ISO 8859-13 Baltic | | macce_bin | macce | 43 | | Yes | 1 | Mac Central European | | macce_general_ci | macce | 38 | Yes | Yes | 1 | Mac Central European | | macce_general_nopad_ci | macce | 1062 | | Yes | 1 | Mac Central European | | macce_nopad_bin | macce | 1067 | | Yes | 1 | Mac Central European | | macroman_bin | macroman | 53 | | Yes | 1 | Mac West European | | macroman_general_ci | macroman | 39 | Yes | Yes | 1 | Mac West European | | macroman_general_nopad_ci | macroman | 1063 | | Yes | 1 | Mac West European | | macroman_nopad_bin | macroman | 1077 | | Yes | 1 | Mac West European | | sjis_bin | sjis | 88 | | Yes | 1 | Shift-JIS Japanese | | sjis_japanese_ci | sjis | 13 | Yes | Yes | 1 | Shift-JIS Japanese | | sjis_japanese_nopad_ci | sjis | 1037 | | Yes | 1 | | | sjis_nopad_bin | sjis | 1112 | | Yes | 1 | | | swe7_bin | swe7 | 82 | | Yes | 1 | 7bit Swedish | | swe7_nopad_bin | swe7 | 1106 | | Yes | 1 | 7bit Swedish | | swe7_swedish_ci | swe7 | 10 | Yes | Yes | 1 | 7bit Swedish | | swe7_swedish_nopad_ci | swe7 | 1034 | | Yes | 1 | 7bit Swedish | | tis620_bin | tis620 | 89 | | Yes | 1 | TIS620 Thai | | tis620_nopad_bin | tis620 | 1113 | | Yes | 1 | | | tis620_thai_ci | tis620 | 18 | Yes | Yes | 4 | TIS620 Thai | | tis620_thai_nopad_ci | tis620 | 1042 | | Yes | 4 | | | 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_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 | | | 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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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 | | | ucs2_bin | ucs2 | 90 | | Yes | 1 | UCS-2 Unicode | | ucs2_croatian_ci | ucs2 | 640 | | Yes | 8 | | | ucs2_croatian_mysql561_ci | ucs2 | 149 | | Yes | 8 | | | ucs2_czech_ci | ucs2 | 138 | | Yes | 8 | | | ucs2_danish_ci | ucs2 | 139 | | Yes | 8 | | | ucs2_esperanto_ci | ucs2 | 145 | | Yes | 8 | | | ucs2_estonian_ci | ucs2 | 134 | | Yes | 8 | | | ucs2_general_ci | ucs2 | 35 | Yes | Yes | 1 | UCS-2 Unicode | | ucs2_general_mysql500_ci | ucs2 | 159 | | Yes | 1 | | | ucs2_general_nopad_ci | ucs2 | 1059 | | Yes | 1 | | | ucs2_german2_ci | ucs2 | 148 | | Yes | 8 | | | ucs2_hungarian_ci | ucs2 | 146 | | Yes | 8 | | | ucs2_icelandic_ci | ucs2 | 129 | | Yes | 8 | | | ucs2_latvian_ci | ucs2 | 130 | | Yes | 8 | | | ucs2_lithuanian_ci | ucs2 | 140 | | Yes | 8 | | | ucs2_myanmar_ci | ucs2 | 641 | | Yes | 8 | | | ucs2_nopad_bin | ucs2 | 1114 | | Yes | 1 | | | ucs2_persian_ci | ucs2 | 144 | | Yes | 8 | | | ucs2_polish_ci | ucs2 | 133 | | Yes | 8 | | | ucs2_romanian_ci | ucs2 | 131 | | Yes | 8 | | | ucs2_roman_ci | ucs2 | 143 | | Yes | 8 | | | ucs2_sinhala_ci | ucs2 | 147 | | Yes | 8 | | | ucs2_slovak_ci | ucs2 | 141 | | Yes | 8 | | | ucs2_slovenian_ci | ucs2 | 132 | | Yes | 8 | | | ucs2_spanish2_ci | ucs2 | 142 | | Yes | 8 | | | ucs2_spanish_ci | ucs2 | 135 | | Yes | 8 | | | ucs2_swedish_ci | ucs2 | 136 | | Yes | 8 | | | ucs2_thai_520_w2 | ucs2 | 642 | | Yes | 4 | | | ucs2_turkish_ci | ucs2 | 137 | | Yes | 8 | | | ucs2_unicode_520_ci | ucs2 | 150 | | Yes | 8 | | | ucs2_unicode_520_nopad_ci | ucs2 | 1174 | | Yes | 8 | | | ucs2_unicode_ci | ucs2 | 128 | | Yes | 8 | | | ucs2_unicode_nopad_ci | ucs2 | 1152 | | Yes | 8 | | | ucs2_vietnamese_ci | ucs2 | 151 | | Yes | 8 | | | ujis_bin | ujis | 91 | | Yes | 1 | EUC-JP Japanese | | ujis_japanese_ci | ujis | 12 | Yes | Yes | 1 | EUC-JP Japanese | | ujis_japanese_nopad_ci | ujis | 1036 | | Yes | 1 | | | ujis_nopad_bin | ujis | 1115 | | Yes | 1 | | | utf16le_bin | utf16le | 62 | | Yes | 1 | UTF-16LE Unicode | | utf16le_general_ci | utf16le | 56 | Yes | Yes | 1 | UTF-16LE Unicode | | utf16le_general_nopad_ci | utf16le | 1080 | | Yes | 1 | UTF-16LE Unicode | | utf16le_nopad_bin | utf16le | 1086 | | Yes | 1 | UTF-16LE Unicode | | utf16_bin | utf16 | 55 | | Yes | 1 | UTF-16 Unicode | | utf16_croatian_ci | utf16 | 672 | | Yes | 8 | | | utf16_croatian_mysql561_ci | utf16 | 122 | | Yes | 8 | | | utf16_czech_ci | utf16 | 111 | | Yes | 8 | | | utf16_danish_ci | utf16 | 112 | | Yes | 8 | | | utf16_esperanto_ci | utf16 | 118 | | Yes | 8 | | | utf16_estonian_ci | utf16 | 107 | | Yes | 8 | | | utf16_general_ci | utf16 | 54 | Yes | Yes | 1 | UTF-16 Unicode | | utf16_general_nopad_ci | utf16 | 1078 | | Yes | 1 | UTF-16 Unicode | | utf16_german2_ci | utf16 | 121 | | Yes | 8 | | | utf16_hungarian_ci | utf16 | 119 | | Yes | 8 | | | utf16_icelandic_ci | utf16 | 102 | | Yes | 8 | | | utf16_latvian_ci | utf16 | 103 | | Yes | 8 | | | utf16_lithuanian_ci | utf16 | 113 | | Yes | 8 | | | utf16_myanmar_ci | utf16 | 673 | | Yes | 8 | | | utf16_nopad_bin | utf16 | 1079 | | Yes | 1 | UTF-16 Unicode | | utf16_persian_ci | utf16 | 117 | | Yes | 8 | | | utf16_polish_ci | utf16 | 106 | | Yes | 8 | | | utf16_romanian_ci | utf16 | 104 | | Yes | 8 | | | utf16_roman_ci | utf16 | 116 | | Yes | 8 | | | utf16_sinhala_ci | utf16 | 120 | | Yes | 8 | | | utf16_slovak_ci | utf16 | 114 | | Yes | 8 | | | utf16_slovenian_ci | utf16 | 105 | | Yes | 8 | | | utf16_spanish2_ci | utf16 | 115 | | Yes | 8 | | | utf16_spanish_ci | utf16 | 108 | | Yes | 8 | | | utf16_swedish_ci | utf16 | 109 | | Yes | 8 | | | utf16_thai_520_w2 | utf16 | 674 | | Yes | 4 | | | utf16_turkish_ci | utf16 | 110 | | Yes | 8 | | | utf16_unicode_520_ci | utf16 | 123 | | Yes | 8 | | | utf16_unicode_520_nopad_ci | utf16 | 1147 | | Yes | 8 | | | utf16_unicode_ci | utf16 | 101 | | Yes | 8 | | | utf16_unicode_nopad_ci | utf16 | 1125 | | Yes | 8 | | | utf16_vietnamese_ci | utf16 | 124 | | Yes | 8 | | | utf32_bin | utf32 | 61 | | Yes | 1 | UTF-32 Unicode | | utf32_croatian_ci | utf32 | 736 | | Yes | 8 | | | utf32_croatian_mysql561_ci | utf32 | 181 | | Yes | 8 | | | utf32_czech_ci | utf32 | 170 | | Yes | 8 | | | utf32_danish_ci | utf32 | 171 | | Yes | 8 | | | utf32_esperanto_ci | utf32 | 177 | | Yes | 8 | | | utf32_estonian_ci | utf32 | 166 | | Yes | 8 | | | utf32_general_ci | utf32 | 60 | Yes | Yes | 1 | UTF-32 Unicode | | utf32_general_nopad_ci | utf32 | 1084 | | Yes | 1 | UTF-32 Unicode | | utf32_german2_ci | utf32 | 180 | | Yes | 8 | | | utf32_hungarian_ci | utf32 | 178 | | Yes | 8 | | | utf32_icelandic_ci | utf32 | 161 | | Yes | 8 | | | utf32_latvian_ci | utf32 | 162 | | Yes | 8 | | | utf32_lithuanian_ci | utf32 | 172 | | Yes | 8 | | | utf32_myanmar_ci | utf32 | 737 | | Yes | 8 | | | utf32_nopad_bin | utf32 | 1085 | | Yes | 1 | UTF-32 Unicode | | utf32_persian_ci | utf32 | 176 | | Yes | 8 | | | utf32_polish_ci | utf32 | 165 | | Yes | 8 | | | utf32_romanian_ci | utf32 | 163 | | Yes | 8 | | | utf32_roman_ci | utf32 | 175 | | Yes | 8 | | | utf32_sinhala_ci | utf32 | 179 | | Yes | 8 | | | utf32_slovak_ci | utf32 | 173 | | Yes | 8 | | | utf32_slovenian_ci | utf32 | 164 | | Yes | 8 | | | utf32_spanish2_ci | utf32 | 174 | | Yes | 8 | | | utf32_spanish_ci | utf32 | 167 | | Yes | 8 | | | utf32_swedish_ci | utf32 | 168 | | Yes | 8 | | | utf32_thai_520_w2 | utf32 | 738 | | Yes | 4 | | | utf32_turkish_ci | utf32 | 169 | | Yes | 8 | | | utf32_unicode_520_ci | utf32 | 182 | | Yes | 8 | | | utf32_unicode_520_nopad_ci | utf32 | 1206 | | Yes | 8 | | | utf32_unicode_ci | utf32 | 160 | | Yes | 8 | | | utf32_unicode_nopad_ci | utf32 | 1184 | | Yes | 8 | | | utf32_vietnamese_ci | utf32 | 183 | | Yes | 8 | | | utf8mb3_bin | utf8mb3 | 83 | | Yes | 1 | UTF-8 Unicode | | utf8mb3_croatian_ci | utf8mb3 | 576 | | Yes | 8 | | | utf8mb3_croatian_mysql561_ci | utf8mb3 | 213 | | Yes | 8 | | | utf8mb3_czech_ci | utf8mb3 | 202 | | Yes | 8 | | | utf8mb3_danish_ci | utf8mb3 | 203 | | Yes | 8 | | | utf8mb3_esperanto_ci | utf8mb3 | 209 | | Yes | 8 | | | utf8mb3_estonian_ci | utf8mb3 | 198 | | Yes | 8 | | | utf8mb3_general_ci | utf8mb3 | 33 | Yes | Yes | 1 | UTF-8 Unicode | | utf8mb3_general_mysql500_ci | utf8mb3 | 223 | | Yes | 1 | | | utf8mb3_general_nopad_ci | utf8mb3 | 1057 | | Yes | 1 | | | utf8mb3_german2_ci | utf8mb3 | 212 | | Yes | 8 | | | utf8mb3_hungarian_ci | utf8mb3 | 210 | | Yes | 8 | | | utf8mb3_icelandic_ci | utf8mb3 | 193 | | Yes | 8 | | | utf8mb3_latvian_ci | utf8mb3 | 194 | | Yes | 8 | | | utf8mb3_lithuanian_ci | utf8mb3 | 204 | | Yes | 8 | | | utf8mb3_myanmar_ci | utf8mb3 | 577 | | Yes | 8 | | | utf8mb3_nopad_bin | utf8mb3 | 1107 | | Yes | 1 | | | utf8mb3_persian_ci | utf8mb3 | 208 | | Yes | 8 | | | utf8mb3_polish_ci | utf8mb3 | 197 | | Yes | 8 | | | utf8mb3_romanian_ci | utf8mb3 | 195 | | Yes | 8 | | | utf8mb3_roman_ci | utf8mb3 | 207 | | Yes | 8 | | | utf8mb3_sinhala_ci | utf8mb3 | 211 | | Yes | 8 | | | utf8mb3_slovak_ci | utf8mb3 | 205 | | Yes | 8 | | | utf8mb3_slovenian_ci | utf8mb3 | 196 | | Yes | 8 | | | utf8mb3_spanish2_ci | utf8mb3 | 206 | | Yes | 8 | | | utf8mb3_spanish_ci | utf8mb3 | 199 | | Yes | 8 | | | utf8mb3_swedish_ci | utf8mb3 | 200 | | Yes | 8 | | | utf8mb3_thai_520_w2 | utf8mb3 | 578 | | Yes | 4 | | | utf8mb3_turkish_ci | utf8mb3 | 201 | | Yes | 8 | | | utf8mb3_unicode_520_ci | utf8mb3 | 214 | | Yes | 8 | | | utf8mb3_unicode_520_nopad_ci | utf8mb3 | 1238 | | Yes | 8 | | | utf8mb3_unicode_ci | utf8mb3 | 192 | | Yes | 8 | | | utf8mb3_unicode_nopad_ci | utf8mb3 | 1216 | | Yes | 8 | | | utf8mb3_vietnamese_ci | utf8mb3 | 215 | | Yes | 8 | | | utf8mb4_0900_ai_ci | utf8mb4 | 255 | | Yes | 8 | Alias for utf8mb4_uca1400_nopad_ai_ci | | utf8mb4_0900_as_ci | utf8mb4 | 305 | | Yes | 8 | Alias for utf8mb4_uca1400_nopad_as_ci | | utf8mb4_0900_as_cs | utf8mb4 | 278 | | Yes | 8 | Alias for utf8mb4_uca1400_nopad_as_cs | | utf8mb4_0900_bin | utf8mb4 | 309 | | Yes | 1 | Alias for utf8mb4_bin | | utf8mb4_bin | utf8mb4 | 46 | | Yes | 1 | UTF-8 Unicode | | utf8mb4_croatian_ci | utf8mb4 | 608 | | Yes | 8 | | | utf8mb4_croatian_mysql561_ci | utf8mb4 | 245 | | Yes | 8 | | | utf8mb4_cs_0900_ai_ci | utf8mb4 | 266 | | Yes | 8 | Alias for utf8mb4_uca1400_czech_nopad_ai_ci | | utf8mb4_cs_0900_as_cs | utf8mb4 | 289 | | Yes | 8 | Alias for utf8mb4_uca1400_czech_nopad_as_cs | | utf8mb4_czech_ci | utf8mb4 | 234 | | Yes | 8 | | | utf8mb4_danish_ci | utf8mb4 | 235 | | Yes | 8 | | | utf8mb4_da_0900_ai_ci | utf8mb4 | 267 | | Yes | 8 | Alias for utf8mb4_uca1400_danish_nopad_ai_ci | | utf8mb4_da_0900_as_cs | utf8mb4 | 290 | | Yes | 8 | Alias for utf8mb4_uca1400_danish_nopad_as_cs | | utf8mb4_de_pb_0900_ai_ci | utf8mb4 | 256 | | Yes | 8 | Alias for utf8mb4_uca1400_german2_nopad_ai_ci | | utf8mb4_de_pb_0900_as_cs | utf8mb4 | 279 | | Yes | 8 | Alias for utf8mb4_uca1400_german2_nopad_as_cs | | utf8mb4_eo_0900_ai_ci | utf8mb4 | 273 | | Yes | 8 | Alias for utf8mb4_uca1400_esperanto_nopad_ai_ci | | utf8mb4_eo_0900_as_cs | utf8mb4 | 296 | | Yes | 8 | Alias for utf8mb4_uca1400_esperanto_nopad_as_cs | | utf8mb4_esperanto_ci | utf8mb4 | 241 | | Yes | 8 | | | utf8mb4_estonian_ci | utf8mb4 | 230 | | Yes | 8 | | | utf8mb4_es_0900_ai_ci | utf8mb4 | 263 | | Yes | 8 | Alias for utf8mb4_uca1400_spanish_nopad_ai_ci | | utf8mb4_es_0900_as_cs | utf8mb4 | 286 | | Yes | 8 | Alias for utf8mb4_uca1400_spanish_nopad_as_cs | | utf8mb4_es_trad_0900_ai_ci | utf8mb4 | 270 | | Yes | 8 | Alias for utf8mb4_uca1400_spanish2_nopad_ai_ci | | utf8mb4_es_trad_0900_as_cs | utf8mb4 | 293 | | Yes | 8 | Alias for utf8mb4_uca1400_spanish2_nopad_as_cs | | utf8mb4_et_0900_ai_ci | utf8mb4 | 262 | | Yes | 8 | Alias for utf8mb4_uca1400_estonian_nopad_ai_ci | | utf8mb4_et_0900_as_cs | utf8mb4 | 285 | | Yes | 8 | Alias for utf8mb4_uca1400_estonian_nopad_as_cs | | utf8mb4_general_ci | utf8mb4 | 45 | Yes | Yes | 1 | UTF-8 Unicode | | utf8mb4_general_nopad_ci | utf8mb4 | 1069 | | Yes | 1 | UTF-8 Unicode | | utf8mb4_german2_ci | utf8mb4 | 244 | | Yes | 8 | | | utf8mb4_hr_0900_ai_ci | utf8mb4 | 275 | | Yes | 8 | Alias for utf8mb4_uca1400_croatian_nopad_ai_ci | | utf8mb4_hr_0900_as_cs | utf8mb4 | 298 | | Yes | 8 | Alias for utf8mb4_uca1400_croatian_nopad_as_cs | | utf8mb4_hungarian_ci | utf8mb4 | 242 | | Yes | 8 | | | utf8mb4_hu_0900_ai_ci | utf8mb4 | 274 | | Yes | 8 | Alias for utf8mb4_uca1400_hungarian_nopad_ai_ci | | utf8mb4_hu_0900_as_cs | utf8mb4 | 297 | | Yes | 8 | Alias for utf8mb4_uca1400_hungarian_nopad_as_cs | | utf8mb4_icelandic_ci | utf8mb4 | 225 | | Yes | 8 | | | utf8mb4_is_0900_ai_ci | utf8mb4 | 257 | | Yes | 8 | Alias for utf8mb4_uca1400_icelandic_nopad_ai_ci | | utf8mb4_is_0900_as_cs | utf8mb4 | 280 | | Yes | 8 | Alias for utf8mb4_uca1400_icelandic_nopad_as_cs | | utf8mb4_latvian_ci | utf8mb4 | 226 | | Yes | 8 | | | utf8mb4_la_0900_ai_ci | utf8mb4 | 271 | | Yes | 8 | Alias for utf8mb4_uca1400_roman_nopad_ai_ci | | utf8mb4_la_0900_as_cs | utf8mb4 | 294 | | Yes | 8 | Alias for utf8mb4_uca1400_roman_nopad_as_cs | | utf8mb4_lithuanian_ci | utf8mb4 | 236 | | Yes | 8 | | | utf8mb4_lt_0900_ai_ci | utf8mb4 | 268 | | Yes | 8 | Alias for utf8mb4_uca1400_lithuanian_nopad_ai_ci | | utf8mb4_lt_0900_as_cs | utf8mb4 | 291 | | Yes | 8 | Alias for utf8mb4_uca1400_lithuanian_nopad_as_cs | | utf8mb4_lv_0900_ai_ci | utf8mb4 | 258 | | Yes | 8 | Alias for utf8mb4_uca1400_latvian_nopad_ai_ci | | utf8mb4_lv_0900_as_cs | utf8mb4 | 281 | | Yes | 8 | Alias for utf8mb4_uca1400_latvian_nopad_as_cs | | utf8mb4_myanmar_ci | utf8mb4 | 609 | | Yes | 8 | | | utf8mb4_nopad_bin | utf8mb4 | 1070 | | Yes | 1 | UTF-8 Unicode | | utf8mb4_persian_ci | utf8mb4 | 240 | | Yes | 8 | | | utf8mb4_pl_0900_ai_ci | utf8mb4 | 261 | | Yes | 8 | Alias for utf8mb4_uca1400_polish_nopad_ai_ci | | utf8mb4_pl_0900_as_cs | utf8mb4 | 284 | | Yes | 8 | Alias for utf8mb4_uca1400_polish_nopad_as_cs | | utf8mb4_polish_ci | utf8mb4 | 229 | | Yes | 8 | | | utf8mb4_romanian_ci | utf8mb4 | 227 | | Yes | 8 | | | utf8mb4_roman_ci | utf8mb4 | 239 | | Yes | 8 | | | utf8mb4_ro_0900_ai_ci | utf8mb4 | 259 | | Yes | 8 | Alias for utf8mb4_uca1400_romanian_nopad_ai_ci | | utf8mb4_ro_0900_as_cs | utf8mb4 | 282 | | Yes | 8 | Alias for utf8mb4_uca1400_romanian_nopad_as_cs | | utf8mb4_sinhala_ci | utf8mb4 | 243 | | Yes | 8 | | | utf8mb4_sk_0900_ai_ci | utf8mb4 | 269 | | Yes | 8 | Alias for utf8mb4_uca1400_slovak_nopad_ai_ci | | utf8mb4_sk_0900_as_cs | utf8mb4 | 292 | | Yes | 8 | Alias for utf8mb4_uca1400_slovak_nopad_as_cs | | utf8mb4_slovak_ci | utf8mb4 | 237 | | Yes | 8 | | | utf8mb4_slovenian_ci | utf8mb4 | 228 | | Yes | 8 | | | utf8mb4_sl_0900_ai_ci | utf8mb4 | 260 | | Yes | 8 | Alias for utf8mb4_uca1400_slovenian_nopad_ai_ci | | utf8mb4_sl_0900_as_cs | utf8mb4 | 283 | | Yes | 8 | Alias for utf8mb4_uca1400_slovenian_nopad_as_cs | | utf8mb4_spanish2_ci | utf8mb4 | 238 | | Yes | 8 | | | utf8mb4_spanish_ci | utf8mb4 | 231 | | Yes | 8 | | | utf8mb4_sv_0900_ai_ci | utf8mb4 | 264 | | Yes | 8 | Alias for utf8mb4_uca1400_swedish_nopad_ai_ci | | utf8mb4_sv_0900_as_cs | utf8mb4 | 287 | | Yes | 8 | Alias for utf8mb4_uca1400_swedish_nopad_as_cs | | utf8mb4_swedish_ci | utf8mb4 | 232 | | Yes | 8 | | | utf8mb4_thai_520_w2 | utf8mb4 | 610 | | Yes | 4 | | | utf8mb4_tr_0900_ai_ci | utf8mb4 | 265 | | Yes | 8 | Alias for utf8mb4_uca1400_turkish_nopad_ai_ci | | utf8mb4_tr_0900_as_cs | utf8mb4 | 288 | | Yes | 8 | Alias for utf8mb4_uca1400_turkish_nopad_as_cs | | utf8mb4_turkish_ci | utf8mb4 | 233 | | Yes | 8 | | | utf8mb4_unicode_520_ci | utf8mb4 | 246 | | Yes | 8 | | | utf8mb4_unicode_520_nopad_ci | utf8mb4 | 1270 | | Yes | 8 | | | utf8mb4_unicode_ci | utf8mb4 | 224 | | Yes | 8 | | | utf8mb4_unicode_nopad_ci | utf8mb4 | 1248 | | Yes | 8 | | | utf8mb4_vietnamese_ci | utf8mb4 | 247 | | Yes | 8 | | | utf8mb4_vi_0900_ai_ci | utf8mb4 | 277 | | Yes | 8 | Alias for utf8mb4_uca1400_vietnamese_nopad_ai_ci | | utf8mb4_vi_0900_as_cs | utf8mb4 | 300 | | Yes | 8 | Alias for utf8mb4_uca1400_vietnamese_nopad_as_cs | +--------------------------------+----------+------+------+-----+---------+--------------------------------------------------+ 550 rows in set (0.005 sec)
The UCA-14.0.0 collations were added in MariaDB 10.10.1.
Before MariaDB 10.6.1, the utf8mb3* collations listed above were named utf8*.
MariaDB 11.4.5 added UCA-9.0.0 collations, as well as a Comment column to information_schema.collations, to make it clear that the UCA-9.0.0 collations are mapped to the UCA-14.0.0 collations. The UCA-9.0.0 collations have mainly been added to make it easy to replicate from MySQL 8.0 to MariaDB 11.4.5 and newer.
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
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.
