Supported character sets
Updated at:
PolarDB-X supports the character sets and collations listed in this topic, organized by edition (Enterprise or Standard) and MySQL version (5.7 or 8.0).
Key differences between versions and editions
| Enterprise edition | Standard edition | |
|---|---|---|
| MySQL 5.7 | UTF8 with UTF8_GERMAN2_CI included | UTF8 without UTF8_GERMAN2_CI |
| MySQL 8.0 | Adds GB18030_2022; UTF8 renamed to UTF8MB3; UTF8MB4 gains 0900-series collations | Same as Enterprise 8.0 |
Enterprise edition
MySQL 5.7
| Character set | Collation |
|---|---|
| ARMSCII8 | ARMSCII8_BIN, ARMSCII8_GENERAL_CI |
| ASCII | ASCII_BIN, ASCII_GENERAL_CI |
| BIG5 | BIG5_BIN, BIG5_CHINESE_CI |
| BINARY | BINARY |
| CP1250 | CP1250_BIN, CP1250_CROATIAN_CI, CP1250_CZECH_CS, CP1250_GENERAL_CI, CP1250_POLISH_CI |
| CP1251 | CP1251_BIN, CP1251_BULGARIAN_CI, CP1251_GENERAL_CI, CP1251_GENERAL_CS, CP1251_UKRAINIAN_CI |
| CP1256 | CP1256_BIN, CP1256_GENERAL_CI |
| CP1257 | CP1257_BIN, CP1257_GENERAL_CI, CP1257_LITHUANIAN_CI |
| CP850 | CP850_BIN, CP850_GENERAL_CI |
| CP852 | CP852_BIN, CP852_GENERAL_CI |
| CP866 | CP866_BIN, CP866_GENERAL_CI |
| CP932 | CP932_BIN, CP932_JAPANESE_CI |
| DEC8 | DEC8_BIN, DEC8_SWEDISH_CI |
| EUCJPMS | EUCJPMS_BIN, EUCJPMS_JAPANESE_CI |
| EUCKR | EUCKR_BIN, EUCKR_KOREAN_CI |
| GB18030 | GB18030_BIN, GB18030_CHINESE_CI, GB18030_UNICODE_520_CI |
| GB2312 | GB2312_BIN, GB2312_CHINESE_CI |
| GBK | GBK_BIN, GBK_CHINESE_CI |
| GEOSTD8 | GEOSTD8_BIN, GEOSTD8_GENERAL_CI |
| GREEK | GREEK_BIN, GREEK_GENERAL_CI |
| HEBREW | HEBREW_BIN, HEBREW_GENERAL_CI |
| HP8 | HP8_BIN, HP8_ENGLISH_CI |
| KEYBCS2 | KEYBCS2_BIN, KEYBCS2_GENERAL_CI |
| KOI8R | KOI8R_BIN, KOI8R_GENERAL_CI |
| KOI8U | KOI8U_BIN, KOI8U_GENERAL_CI |
| LATIN1 | LATIN1_BIN, LATIN1_DANISH_CI, LATIN1_GENERAL_CI, LATIN1_GENERAL_CS, LATIN1_GERMAN1_CI, LATIN1_GERMAN2_CI, LATIN1_SPANISH_CI, LATIN1_SWEDISH_CI |
| LATIN2 | LATIN2_BIN, LATIN2_CROATIAN_CI, LATIN2_CZECH_CS, LATIN2_GENERAL_CI, LATIN2_HUNGARIAN_CI |
| LATIN5 | LATIN5_BIN, LATIN5_TURKISH_CI |
| LATIN7 | LATIN7_BIN, LATIN7_ESTONIAN_CS, LATIN7_GENERAL_CI, LATIN7_GENERAL_CS |
| MACCE | MACCE_BIN, MACCE_GENERAL_CI |
| MACROMAN | MACROMAN_BIN, MACROMAN_GENERAL_CI |
| SJIS | SJIS_BIN, SJIS_JAPANESE_CI |
| SWE7 | SWE7_BIN, SWE7_SWEDISH_CI |
| TIS620 | TIS620_BIN, TIS620_THAI_CI |
| UCS2 | UCS2_BIN, UCS2_CROATIAN_CI, UCS2_CZECH_CI, UCS2_DANISH_CI, UCS2_ESPERANTO_CI, UCS2_ESTONIAN_CI, UCS2_GENERAL_CI, UCS2_GENERAL_MYSQL500_CI, UCS2_GERMAN2_CI, UCS2_HUNGARIAN_CI, UCS2_ICELANDIC_CI, UCS2_LATVIAN_CI, UCS2_LITHUANIAN_CI, UCS2_PERSIAN_CI, UCS2_POLISH_CI, UCS2_ROMANIAN_CI, UCS2_ROMAN_CI, UCS2_SINHALA_CI, UCS2_SLOVAK_CI, UCS2_SLOVENIAN_CI, UCS2_SPANISH2_CI, UCS2_SPANISH_CI, UCS2_SWEDISH_CI, UCS2_TURKISH_CI, UCS2_UNICODE_520_CI, UCS2_UNICODE_CI, UCS2_VIETNAMESE_CI |
| UJIS | UJIS_BIN, UJIS_JAPANESE_CI |
| UTF16 | UTF16_BIN, UTF16_CROATIAN_CI, UTF16_CZECH_CI, UTF16_DANISH_CI, UTF16_ESPERANTO_CI, UTF16_ESTONIAN_CI, UTF16_GENERAL_CI, UTF16_GERMAN2_CI, UTF16_HUNGARIAN_CI, UTF16_ICELANDIC_CI, UTF16_LATVIAN_CI, UTF16_LITHUANIAN_CI, UTF16_PERSIAN_CI, UTF16_POLISH_CI, UTF16_ROMANIAN_CI, UTF16_ROMAN_CI, UTF16_SINHALA_CI, UTF16_SLOVAK_CI, UTF16_SLOVENIAN_CI, UTF16_SPANISH2_CI, UTF16_SPANISH_CI, UTF16_SWEDISH_CI, UTF16_TURKISH_CI, UTF16_UNICODE_520_CI, UTF16_UNICODE_CI, UTF16_VIETNAMESE_CI |
| UTF16LE | UTF16LE_BIN, UTF16LE_GENERAL_CI |
| UTF32 | UTF32_BIN, UTF32_CROATIAN_CI, UTF32_CZECH_CI, UTF32_DANISH_CI, UTF32_ESPERANTO_CI, UTF32_ESTONIAN_CI, UTF32_GENERAL_CI, UTF32_GERMAN2_CI, UTF32_HUNGARIAN_CI, UTF32_ICELANDIC_CI, UTF32_LATVIAN_CI, UTF32_LITHUANIAN_CI, UTF32_PERSIAN_CI, UTF32_POLISH_CI, UTF32_ROMANIAN_CI, UTF32_ROMAN_CI, UTF32_SINHALA_CI, UTF32_SLOVAK_CI, UTF32_SLOVENIAN_CI, UTF32_SPANISH2_CI, UTF32_SPANISH_CI, UTF32_SWEDISH_CI, UTF32_TURKISH_CI, UTF32_UNICODE_520_CI, UTF32_UNICODE_CI, UTF32_VIETNAMESE_CI |
| UTF8 | UTF8_BIN, UTF8_CROATIAN_CI, UTF8_CZECH_CI, UTF8_DANISH_CI, UTF8_ESPERANTO_CI, UTF8_ESTONIAN_CI, UTF8_GENERAL_CI, UTF8_GENERAL_MYSQL500_CI, UTF8_GERMAN2_CI, UTF8_HUNGARIAN_CI, UTF8_ICELANDIC_CI, UTF8_LATVIAN_CI, UTF8_LITHUANIAN_CI, UTF8_PERSIAN_CI, UTF8_POLISH_CI, UTF8_ROMANIAN_CI, UTF8_ROMAN_CI, UTF8_SINHALA_CI, UTF8_SLOVAK_CI, UTF8_SLOVENIAN_CI, UTF8_SPANISH2_CI, UTF8_SPANISH_CI, UTF8_SWEDISH_CI, UTF8_TURKISH_CI, UTF8_UNICODE_520_CI, UTF8_UNICODE_CI, UTF8_VIETNAMESE_CI |
| UTF8MB4 | UTF8MB4_BIN, UTF8MB4_CROATIAN_CI, UTF8MB4_CZECH_CI, UTF8MB4_DANISH_CI, UTF8MB4_ESPERANTO_CI, UTF8MB4_ESTONIAN_CI, UTF8MB4_GENERAL_CI, UTF8MB4_GERMAN2_CI, UTF8MB4_HUNGARIAN_CI, UTF8MB4_ICELANDIC_CI, UTF8MB4_LATVIAN_CI, UTF8MB4_LITHUANIAN_CI, UTF8MB4_PERSIAN_CI, UTF8MB4_POLISH_CI, UTF8MB4_ROMANIAN_CI, UTF8MB4_ROMAN_CI, UTF8MB4_SINHALA_CI, UTF8MB4_SLOVAK_CI, UTF8MB4_SLOVENIAN_CI, UTF8MB4_SPANISH2_CI, UTF8MB4_SPANISH_CI, UTF8MB4_SWEDISH_CI, UTF8MB4_TURKISH_CI, UTF8MB4_UNICODE_520_CI, UTF8MB4_UNICODE_CI, UTF8MB4_VIETNAMESE_CI |
MySQL 8.0
MySQL 8.0 adds GB18030_2022, renames UTF8 to UTF8MB3, and extends UTF8MB4 with 0900-series collations.
| Character set | Collation |
|---|---|
| ARMSCII8 | ARMSCII8_BIN, ARMSCII8_GENERAL_CI |
| ASCII | ASCII_BIN, ASCII_GENERAL_CI |
| BIG5 | BIG5_BIN, BIG5_CHINESE_CI |
| BINARY | BINARY |
| CP1250 | CP1250_BIN, CP1250_CROATIAN_CI, CP1250_CZECH_CS, CP1250_GENERAL_CI, CP1250_POLISH_CI |
| CP1251 | CP1251_BIN, CP1251_BULGARIAN_CI, CP1251_GENERAL_CI, CP1251_GENERAL_CS, CP1251_UKRAINIAN_CI |
| CP1256 | CP1256_BIN, CP1256_GENERAL_CI |
| CP1257 | CP1257_BIN, CP1257_GENERAL_CI, CP1257_LITHUANIAN_CI |
| CP850 | CP850_BIN, CP850_GENERAL_CI |
| CP852 | CP852_BIN, CP852_GENERAL_CI |
| CP866 | CP866_BIN, CP866_GENERAL_CI |
| CP932 | CP932_BIN, CP932_JAPANESE_CI |
| DEC8 | DEC8_BIN, DEC8_SWEDISH_CI |
| EUCJPMS | EUCJPMS_BIN, EUCJPMS_JAPANESE_CI |
| EUCKR | EUCKR_BIN, EUCKR_KOREAN_CI |
| GB18030 | GB18030_BIN, GB18030_CHINESE_CI, GB18030_UNICODE_520_CI |
| GB18030_2022 | GB18030_2022_BIN, GB18030_2022_CHINESE_CI |
| GB2312 | GB2312_BIN, GB2312_CHINESE_CI |
| GBK | GBK_BIN, GBK_CHINESE_CI |
| GEOSTD8 | GEOSTD8_BIN, GEOSTD8_GENERAL_CI |
| GREEK | GREEK_BIN, GREEK_GENERAL_CI |
| HEBREW | HEBREW_BIN, HEBREW_GENERAL_CI |
| HP8 | HP8_BIN, HP8_ENGLISH_CI |
| KEYBCS2 | KEYBCS2_BIN, KEYBCS2_GENERAL_CI |
| KOI8R | KOI8R_BIN, KOI8R_GENERAL_CI |
| KOI8U | KOI8U_BIN, KOI8U_GENERAL_CI |
| LATIN1 | LATIN1_BIN, LATIN1_DANISH_CI, LATIN1_GENERAL_CI, LATIN1_GENERAL_CS, LATIN1_GERMAN1_CI, LATIN1_GERMAN2_CI, LATIN1_SPANISH_CI, LATIN1_SWEDISH_CI |
| LATIN2 | LATIN2_BIN, LATIN2_CROATIAN_CI, LATIN2_CZECH_CS, LATIN2_GENERAL_CI, LATIN2_HUNGARIAN_CI |
| LATIN5 | LATIN5_BIN, LATIN5_TURKISH_CI |
| LATIN7 | LATIN7_BIN, LATIN7_ESTONIAN_CS, LATIN7_GENERAL_CI, LATIN7_GENERAL_CS |
| MACCE | MACCE_BIN, MACCE_GENERAL_CI |
| MACROMAN | MACROMAN_BIN, MACROMAN_GENERAL_CI |
| SJIS | SJIS_BIN, SJIS_JAPANESE_CI |
| SWE7 | SWE7_BIN, SWE7_SWEDISH_CI |
| TIS620 | TIS620_BIN, TIS620_THAI_CI |
| UCS2 | UCS2_BIN, UCS2_CROATIAN_CI, UCS2_CZECH_CI, UCS2_DANISH_CI, UCS2_ESPERANTO_CI, UCS2_ESTONIAN_CI, UCS2_GENERAL_CI, UCS2_GENERAL_MYSQL500_CI, UCS2_GERMAN2_CI, UCS2_HUNGARIAN_CI, UCS2_ICELANDIC_CI, UCS2_LATVIAN_CI, UCS2_LITHUANIAN_CI, UCS2_PERSIAN_CI, UCS2_POLISH_CI, UCS2_ROMANIAN_CI, UCS2_ROMAN_CI, UCS2_SINHALA_CI, UCS2_SLOVAK_CI, UCS2_SLOVENIAN_CI, UCS2_SPANISH2_CI, UCS2_SPANISH_CI, UCS2_SWEDISH_CI, UCS2_TURKISH_CI, UCS2_UNICODE_520_CI, UCS2_UNICODE_CI, UCS2_VIETNAMESE_CI |
| UJIS | UJIS_BIN, UJIS_JAPANESE_CI |
| UTF16 | UTF16_BIN, UTF16_CROATIAN_CI, UTF16_CZECH_CI, UTF16_DANISH_CI, UTF16_ESPERANTO_CI, UTF16_ESTONIAN_CI, UTF16_GENERAL_CI, UTF16_GERMAN2_CI, UTF16_HUNGARIAN_CI, UTF16_ICELANDIC_CI, UTF16_LATVIAN_CI, UTF16_LITHUANIAN_CI, UTF16_PERSIAN_CI, UTF16_POLISH_CI, UTF16_ROMANIAN_CI, UTF16_ROMAN_CI, UTF16_SINHALA_CI, UTF16_SLOVAK_CI, UTF16_SLOVENIAN_CI, UTF16_SPANISH2_CI, UTF16_SPANISH_CI, UTF16_SWEDISH_CI, UTF16_TURKISH_CI, UTF16_UNICODE_520_CI, UTF16_UNICODE_CI, UTF16_VIETNAMESE_CI |
| UTF16LE | UTF16LE_BIN, UTF16LE_GENERAL_CI |
| UTF32 | UTF32_BIN, UTF32_CROATIAN_CI, UTF32_CZECH_CI, UTF32_DANISH_CI, UTF32_ESPERANTO_CI, UTF32_ESTONIAN_CI, UTF32_GENERAL_CI, UTF32_GERMAN2_CI, UTF32_HUNGARIAN_CI, UTF32_ICELANDIC_CI, UTF32_LATVIAN_CI, UTF32_LITHUANIAN_CI, UTF32_PERSIAN_CI, UTF32_POLISH_CI, UTF32_ROMANIAN_CI, UTF32_ROMAN_CI, UTF32_SINHALA_CI, UTF32_SLOVAK_CI, UTF32_SLOVENIAN_CI, UTF32_SPANISH2_CI, UTF32_SPANISH_CI, UTF32_SWEDISH_CI, UTF32_TURKISH_CI, UTF32_UNICODE_520_CI, UTF32_UNICODE_CI, UTF32_VIETNAMESE_CI |
| UTF8MB3 | UTF8MB3_BIN, UTF8MB3_CROATIAN_CI, UTF8MB3_CZECH_CI, UTF8MB3_DANISH_CI, UTF8MB3_ESPERANTO_CI, UTF8MB3_ESTONIAN_CI, UTF8MB3_GENERAL_CI, UTF8MB3_GENERAL_MYSQL500_CI, UTF8MB3_GERMAN2_CI, UTF8MB3_HUNGARIAN_CI, UTF8MB3_ICELANDIC_CI, UTF8MB3_LATVIAN_CI, UTF8MB3_LITHUANIAN_CI, UTF8MB3_PERSIAN_CI, UTF8MB3_POLISH_CI, UTF8MB3_ROMANIAN_CI, UTF8MB3_ROMAN_CI, UTF8MB3_SINHALA_CI, UTF8MB3_SLOVAK_CI, UTF8MB3_SLOVENIAN_CI, UTF8MB3_SPANISH2_CI, UTF8MB3_SPANISH_CI, UTF8MB3_SWEDISH_CI, UTF8MB3_TOLOWER_CI, UTF8MB3_TURKISH_CI, UTF8MB3_UNICODE_520_CI, UTF8MB3_UNICODE_CI, UTF8MB3_VIETNAMESE_CI |
| UTF8MB4 | UTF8MB4_0900_AI_CI, UTF8MB4_0900_AS_CI, UTF8MB4_0900_AS_CS, UTF8MB4_0900_BIN, UTF8MB4_BG_0900_AI_CI, UTF8MB4_BG_0900_AS_CS, UTF8MB4_BIN, UTF8MB4_BS_0900_AI_CI, UTF8MB4_BS_0900_AS_CS, UTF8MB4_CROATIAN_CI, UTF8MB4_CS_0900_AI_CI, UTF8MB4_CS_0900_AS_CS, UTF8MB4_CZECH_CI, UTF8MB4_DANISH_CI, UTF8MB4_DA_0900_AI_CI, UTF8MB4_DA_0900_AS_CS, UTF8MB4_DE_PB_0900_AI_CI, UTF8MB4_DE_PB_0900_AS_CS, UTF8MB4_EO_0900_AI_CI, UTF8MB4_EO_0900_AS_CS, UTF8MB4_ESPERANTO_CI, UTF8MB4_ESTONIAN_CI, UTF8MB4_ES_0900_AI_CI, UTF8MB4_ES_0900_AS_CS, UTF8MB4_ES_TRAD_0900_AI_CI, UTF8MB4_ES_TRAD_0900_AS_CS, UTF8MB4_ET_0900_AI_CI, UTF8MB4_ET_0900_AS_CS, UTF8MB4_GENERAL_CI, UTF8MB4_GERMAN2_CI, UTF8MB4_GL_0900_AI_CI, UTF8MB4_GL_0900_AS_CS, UTF8MB4_HR_0900_AI_CI, UTF8MB4_HR_0900_AS_CS, UTF8MB4_HUNGARIAN_CI, UTF8MB4_HU_0900_AI_CI, UTF8MB4_HU_0900_AS_CS, UTF8MB4_ICELANDIC_CI, UTF8MB4_IS_0900_AI_CI, UTF8MB4_IS_0900_AS_CS, UTF8MB4_JA_0900_AS_CS, UTF8MB4_JA_0900_AS_CS_KS, UTF8MB4_LATVIAN_CI, UTF8MB4_LA_0900_AI_CI, UTF8MB4_LA_0900_AS_CS, UTF8MB4_LITHUANIAN_CI, UTF8MB4_LT_0900_AI_CI, UTF8MB4_LT_0900_AS_CS, UTF8MB4_LV_0900_AI_CI, UTF8MB4_LV_0900_AS_CS, UTF8MB4_MN_CYRL_0900_AI_CI, UTF8MB4_MN_CYRL_0900_AS_CS, UTF8MB4_NB_0900_AI_CI, UTF8MB4_NB_0900_AS_CS, UTF8MB4_NN_0900_AI_CI, UTF8MB4_NN_0900_AS_CS, UTF8MB4_PERSIAN_CI, UTF8MB4_PL_0900_AI_CI, UTF8MB4_PL_0900_AS_CS, UTF8MB4_POLISH_CI, UTF8MB4_ROMANIAN_CI, UTF8MB4_ROMAN_CI, UTF8MB4_RO_0900_AI_CI, UTF8MB4_RO_0900_AS_CS, UTF8MB4_RU_0900_AI_CI, UTF8MB4_RU_0900_AS_CS, UTF8MB4_SINHALA_CI, UTF8MB4_SK_0900_AI_CI, UTF8MB4_SK_0900_AS_CS, UTF8MB4_SLOVAK_CI, UTF8MB4_SLOVENIAN_CI, UTF8MB4_SL_0900_AI_CI, UTF8MB4_SL_0900_AS_CS, UTF8MB4_SPANISH2_CI, UTF8MB4_SPANISH_CI, UTF8MB4_SR_LATN_0900_AI_CI, UTF8MB4_SR_LATN_0900_AS_CS, UTF8MB4_SV_0900_AI_CI, UTF8MB4_SV_0900_AS_CS, UTF8MB4_SWEDISH_CI, UTF8MB4_TR_0900_AI_CI, UTF8MB4_TR_0900_AS_CS, UTF8MB4_TURKISH_CI, UTF8MB4_UNICODE_520_CI, UTF8MB4_UNICODE_CI, UTF8MB4_VIETNAMESE_CI, UTF8MB4_VI_0900_AI_CI, UTF8MB4_VI_0900_AS_CS, UTF8MB4_ZH_0900_AS_CS |
Standard edition
MySQL 5.7
Identical to Enterprise edition MySQL 5.7, except that UTF8 does not include UTF8_GERMAN2_CI.
| Character set | Collation |
|---|---|
| ARMSCII8 | ARMSCII8_BIN, ARMSCII8_GENERAL_CI |
| ASCII | ASCII_BIN, ASCII_GENERAL_CI |
| BIG5 | BIG5_BIN, BIG5_CHINESE_CI |
| BINARY | BINARY |
| CP1250 | CP1250_BIN, CP1250_CROATIAN_CI, CP1250_CZECH_CS, CP1250_GENERAL_CI, CP1250_POLISH_CI |
| CP1251 | CP1251_BIN, CP1251_BULGARIAN_CI, CP1251_GENERAL_CI, CP1251_GENERAL_CS, CP1251_UKRAINIAN_CI |
| CP1256 | CP1256_BIN, CP1256_GENERAL_CI |
| CP1257 | CP1257_BIN, CP1257_GENERAL_CI, CP1257_LITHUANIAN_CI |
| CP850 | CP850_BIN, CP850_GENERAL_CI |
| CP852 | CP852_BIN, CP852_GENERAL_CI |
| CP866 | CP866_BIN, CP866_GENERAL_CI |
| CP932 | CP932_BIN, CP932_JAPANESE_CI |
| DEC8 | DEC8_BIN, DEC8_SWEDISH_CI |
| EUCJPMS | EUCJPMS_BIN, EUCJPMS_JAPANESE_CI |
| EUCKR | EUCKR_BIN, EUCKR_KOREAN_CI |
| GB18030 | GB18030_BIN, GB18030_CHINESE_CI, GB18030_UNICODE_520_CI |
| GB2312 | GB2312_BIN, GB2312_CHINESE_CI |
| GBK | GBK_BIN, GBK_CHINESE_CI |
| GEOSTD8 | GEOSTD8_BIN, GEOSTD8_GENERAL_CI |
| GREEK | GREEK_BIN, GREEK_GENERAL_CI |
| HEBREW | HEBREW_BIN, HEBREW_GENERAL_CI |
| HP8 | HP8_BIN, HP8_ENGLISH_CI |
| KEYBCS2 | KEYBCS2_BIN, KEYBCS2_GENERAL_CI |
| KOI8R | KOI8R_BIN, KOI8R_GENERAL_CI |
| KOI8U | KOI8U_BIN, KOI8U_GENERAL_CI |
| LATIN1 | LATIN1_BIN, LATIN1_DANISH_CI, LATIN1_GENERAL_CI, LATIN1_GENERAL_CS, LATIN1_GERMAN1_CI, LATIN1_GERMAN2_CI, LATIN1_SPANISH_CI, LATIN1_SWEDISH_CI |
| LATIN2 | LATIN2_BIN, LATIN2_CROATIAN_CI, LATIN2_CZECH_CS, LATIN2_GENERAL_CI, LATIN2_HUNGARIAN_CI |
| LATIN5 | LATIN5_BIN, LATIN5_TURKISH_CI |
| LATIN7 | LATIN7_BIN, LATIN7_ESTONIAN_CS, LATIN7_GENERAL_CI, LATIN7_GENERAL_CS |
| MACCE | MACCE_BIN, MACCE_GENERAL_CI |
| MACROMAN | MACROMAN_BIN, MACROMAN_GENERAL_CI |
| SJIS | SJIS_BIN, SJIS_JAPANESE_CI |
| SWE7 | SWE7_BIN, SWE7_SWEDISH_CI |
| TIS620 | TIS620_BIN, TIS620_THAI_CI |
| UCS2 | UCS2_BIN, UCS2_CROATIAN_CI, UCS2_CZECH_CI, UCS2_DANISH_CI, UCS2_ESPERANTO_CI, UCS2_ESTONIAN_CI, UCS2_GENERAL_CI, UCS2_GENERAL_MYSQL500_CI, UCS2_GERMAN2_CI, UCS2_HUNGARIAN_CI, UCS2_ICELANDIC_CI, UCS2_LATVIAN_CI, UCS2_LITHUANIAN_CI, UCS2_PERSIAN_CI, UCS2_POLISH_CI, UCS2_ROMANIAN_CI, UCS2_ROMAN_CI, UCS2_SINHALA_CI, UCS2_SLOVAK_CI, UCS2_SLOVENIAN_CI, UCS2_SPANISH2_CI, UCS2_SPANISH_CI, UCS2_SWEDISH_CI, UCS2_TURKISH_CI, UCS2_UNICODE_520_CI, UCS2_UNICODE_CI, UCS2_VIETNAMESE_CI |
| UJIS | UJIS_BIN, UJIS_JAPANESE_CI |
| UTF16 | UTF16_BIN, UTF16_CROATIAN_CI, UTF16_CZECH_CI, UTF16_DANISH_CI, UTF16_ESPERANTO_CI, UTF16_ESTONIAN_CI, UTF16_GENERAL_CI, UTF16_GERMAN2_CI, UTF16_HUNGARIAN_CI, UTF16_ICELANDIC_CI, UTF16_LATVIAN_CI, UTF16_LITHUANIAN_CI, UTF16_PERSIAN_CI, UTF16_POLISH_CI, UTF16_ROMANIAN_CI, UTF16_ROMAN_CI, UTF16_SINHALA_CI, UTF16_SLOVAK_CI, UTF16_SLOVENIAN_CI, UTF16_SPANISH2_CI, UTF16_SPANISH_CI, UTF16_SWEDISH_CI, UTF16_TURKISH_CI, UTF16_UNICODE_520_CI, UTF16_UNICODE_CI, UTF16_VIETNAMESE_CI |
| UTF16LE | UTF16LE_BIN, UTF16LE_GENERAL_CI |
| UTF32 | UTF32_BIN, UTF32_CROATIAN_CI, UTF32_CZECH_CI, UTF32_DANISH_CI, UTF32_ESPERANTO_CI, UTF32_ESTONIAN_CI, UTF32_GENERAL_CI, UTF32_GERMAN2_CI, UTF32_HUNGARIAN_CI, UTF32_ICELANDIC_CI, UTF32_LATVIAN_CI, UTF32_LITHUANIAN_CI, UTF32_PERSIAN_CI, UTF32_POLISH_CI, UTF32_ROMANIAN_CI, UTF32_ROMAN_CI, UTF32_SINHALA_CI, UTF32_SLOVAK_CI, UTF32_SLOVENIAN_CI, UTF32_SPANISH2_CI, UTF32_SPANISH_CI, UTF32_SWEDISH_CI, UTF32_TURKISH_CI, UTF32_UNICODE_520_CI, UTF32_UNICODE_CI, UTF32_VIETNAMESE_CI |
| UTF8 | UTF8_BIN, UTF8_CROATIAN_CI, UTF8_CZECH_CI, UTF8_DANISH_CI, UTF8_ESPERANTO_CI, UTF8_ESTONIAN_CI, UTF8_GENERAL_CI, UTF8_GENERAL_MYSQL500_CI, UTF8_HUNGARIAN_CI, UTF8_ICELANDIC_CI, UTF8_LATVIAN_CI, UTF8_LITHUANIAN_CI, UTF8_PERSIAN_CI, UTF8_POLISH_CI, UTF8_ROMANIAN_CI, UTF8_ROMAN_CI, UTF8_SINHALA_CI, UTF8_SLOVAK_CI, UTF8_SLOVENIAN_CI, UTF8_SPANISH2_CI, UTF8_SPANISH_CI, UTF8_SWEDISH_CI, UTF8_TURKISH_CI, UTF8_UNICODE_520_CI, UTF8_UNICODE_CI, UTF8_VIETNAMESE_CI |
| UTF8MB4 | UTF8MB4_BIN, UTF8MB4_CROATIAN_CI, UTF8MB4_CZECH_CI, UTF8MB4_DANISH_CI, UTF8MB4_ESPERANTO_CI, UTF8MB4_ESTONIAN_CI, UTF8MB4_GENERAL_CI, UTF8MB4_GERMAN2_CI, UTF8MB4_HUNGARIAN_CI, UTF8MB4_ICELANDIC_CI, UTF8MB4_LATVIAN_CI, UTF8MB4_LITHUANIAN_CI, UTF8MB4_PERSIAN_CI, UTF8MB4_POLISH_CI, UTF8MB4_ROMANIAN_CI, UTF8MB4_ROMAN_CI, UTF8MB4_SINHALA_CI, UTF8MB4_SLOVAK_CI, UTF8MB4_SLOVENIAN_CI, UTF8MB4_SPANISH2_CI, UTF8MB4_SPANISH_CI, UTF8MB4_SWEDISH_CI, UTF8MB4_TURKISH_CI, UTF8MB4_UNICODE_520_CI, UTF8MB4_UNICODE_CI, UTF8MB4_VIETNAMESE_CI |
MySQL 8.0
MySQL 8.0 adds GB18030_2022, renames UTF8 to UTF8MB3, and extends UTF8MB4 with 0900-series collations.
| Character set | Collation |
|---|---|
| ARMSCII8 | ARMSCII8_BIN, ARMSCII8_GENERAL_CI |
| ASCII | ASCII_BIN, ASCII_GENERAL_CI |
| BIG5 | BIG5_BIN, BIG5_CHINESE_CI |
| BINARY | BINARY |
| CP1250 | CP1250_BIN, CP1250_CROATIAN_CI, CP1250_CZECH_CS, CP1250_GENERAL_CI, CP1250_POLISH_CI |
| CP1251 | CP1251_BIN, CP1251_BULGARIAN_CI, CP1251_GENERAL_CI, CP1251_GENERAL_CS, CP1251_UKRAINIAN_CI |
| CP1256 | CP1256_BIN, CP1256_GENERAL_CI |
| CP1257 | CP1257_BIN, CP1257_GENERAL_CI, CP1257_LITHUANIAN_CI |
| CP850 | CP850_BIN, CP850_GENERAL_CI |
| CP852 | CP852_BIN, CP852_GENERAL_CI |
| CP866 | CP866_BIN, CP866_GENERAL_CI |
| CP932 | CP932_BIN, CP932_JAPANESE_CI |
| DEC8 | DEC8_BIN, DEC8_SWEDISH_CI |
| EUCJPMS | EUCJPMS_BIN, EUCJPMS_JAPANESE_CI |
| EUCKR | EUCKR_BIN, EUCKR_KOREAN_CI |
| GB18030 | GB18030_BIN, GB18030_CHINESE_CI, GB18030_UNICODE_520_CI |
| GB18030_2022 | GB18030_2022_BIN, GB18030_2022_CHINESE_CI |
| GB2312 | GB2312_BIN, GB2312_CHINESE_CI |
| GBK | GBK_BIN, GBK_CHINESE_CI |
| GEOSTD8 | GEOSTD8_BIN, GEOSTD8_GENERAL_CI |
| GREEK | GREEK_BIN |
| HEBREW | HEBREW_BIN, HEBREW_GENERAL_CI |
| HP8 | HP8_BIN, HP8_ENGLISH_CI |
| KEYBCS2 | KEYBCS2_BIN, KEYBCS2_GENERAL_CI |
| KOI8R | KOI8R_BIN, KOI8R_GENERAL_CI |
| KOI8U | KOI8U_BIN, KOI8U_GENERAL_CI |
| LATIN1 | LATIN1_BIN, LATIN1_DANISH_CI, LATIN1_GENERAL_CI, LATIN1_GENERAL_CS, LATIN1_GERMAN1_CI, LATIN1_GERMAN2_CI, LATIN1_SPANISH_CI, LATIN1_SWEDISH_CI |
| LATIN2 | LATIN2_BIN, LATIN2_CROATIAN_CI, LATIN2_CZECH_CS, LATIN2_GENERAL_CI, LATIN2_HUNGARIAN_CI |
| LATIN5 | LATIN5_BIN, LATIN5_TURKISH_CI |
| LATIN7 | LATIN7_BIN, LATIN7_ESTONIAN_CS, LATIN7_GENERAL_CI, LATIN7_GENERAL_CS |
| MACCE | MACCE_BIN, MACCE_GENERAL_CI |
| MACROMAN | MACROMAN_BIN, MACROMAN_GENERAL_CI |
| SJIS | SJIS_BIN, SJIS_JAPANESE_CI |
| SWE7 | SWE7_BIN, SWE7_SWEDISH_CI |
| TIS620 | TIS620_BIN, TIS620_THAI_CI |
| UCS2 | UCS2_BIN, UCS2_CROATIAN_CI, UCS2_CZECH_CI, UCS2_DANISH_CI, UCS2_ESPERANTO_CI, UCS2_ESTONIAN_CI, UCS2_GENERAL_CI, UCS2_GENERAL_MYSQL500_CI, UCS2_GERMAN2_CI, UCS2_HUNGARIAN_CI, UCS2_ICELANDIC_CI, UCS2_LATVIAN_CI, UCS2_LITHUANIAN_CI, UCS2_PERSIAN_CI, UCS2_POLISH_CI, UCS2_ROMANIAN_CI, UCS2_ROMAN_CI, UCS2_SINHALA_CI, UCS2_SLOVAK_CI, UCS2_SLOVENIAN_CI, UCS2_SPANISH2_CI, UCS2_SPANISH_CI, UCS2_SWEDISH_CI, UCS2_TURKISH_CI, UCS2_UNICODE_520_CI, UCS2_UNICODE_CI, UCS2_VIETNAMESE_CI |
| UJIS | UJIS_BIN, UJIS_JAPANESE_CI |
| UTF16 | UTF16_BIN, UTF16_CROATIAN_CI, UTF16_CZECH_CI, UTF16_DANISH_CI, UTF16_ESPERANTO_CI, UTF16_ESTONIAN_CI, UTF16_GENERAL_CI, UTF16_GERMAN2_CI, UTF16_HUNGARIAN_CI, UTF16_ICELANDIC_CI, UTF16_LATVIAN_CI, UTF16_LITHUANIAN_CI, UTF16_PERSIAN_CI, UTF16_POLISH_CI, UTF16_ROMANIAN_CI, UTF16_ROMAN_CI, UTF16_SINHALA_CI, UTF16_SLOVAK_CI, UTF16_SLOVENIAN_CI, UTF16_SPANISH2_CI, UTF16_SPANISH_CI, UTF16_SWEDISH_CI, UTF16_TURKISH_CI, UTF16_UNICODE_520_CI, UTF16_UNICODE_CI, UTF16_VIETNAMESE_CI |
| UTF16LE | UTF16LE_BIN, UTF16LE_GENERAL_CI |
| UTF32 | UTF32_BIN, UTF32_CROATIAN_CI, UTF32_CZECH_CI, UTF32_DANISH_CI, UTF32_ESPERANTO_CI, UTF32_ESTONIAN_CI, UTF32_GENERAL_CI, UTF32_GERMAN2_CI, UTF32_HUNGARIAN_CI, UTF32_ICELANDIC_CI, UTF32_LATVIAN_CI, UTF32_LITHUANIAN_CI, UTF32_PERSIAN_CI, UTF32_POLISH_CI, UTF32_ROMANIAN_CI, UTF32_ROMAN_CI, UTF32_SINHALA_CI, UTF32_SLOVAK_CI, UTF32_SLOVENIAN_CI, UTF32_SPANISH2_CI, UTF32_SPANISH_CI, UTF32_SWEDISH_CI, UTF32_TURKISH_CI, UTF32_UNICODE_520_CI, UTF32_UNICODE_CI, UTF32_VIETNAMESE_CI |
| UTF8MB3 | UTF8MB3_BIN, UTF8MB3_CROATIAN_CI, UTF8MB3_CZECH_CI, UTF8MB3_DANISH_CI, UTF8MB3_ESPERANTO_CI, UTF8MB3_ESTONIAN_CI, UTF8MB3_GENERAL_CI, UTF8MB3_GENERAL_MYSQL500_CI, UTF8MB3_GERMAN2_CI, UTF8MB3_HUNGARIAN_CI, UTF8MB3_ICELANDIC_CI, UTF8MB3_LATVIAN_CI, UTF8MB3_LITHUANIAN_CI, UTF8MB3_PERSIAN_CI, UTF8MB3_POLISH_CI, UTF8MB3_ROMANIAN_CI, UTF8MB3_ROMAN_CI, UTF8MB3_SINHALA_CI, UTF8MB3_SLOVAK_CI, UTF8MB3_SLOVENIAN_CI, UTF8MB3_SPANISH2_CI, UTF8MB3_SPANISH_CI, UTF8MB3_SWEDISH_CI, UTF8MB3_TOLOWER_CI, UTF8MB3_TURKISH_CI, UTF8MB3_UNICODE_520_CI, UTF8MB3_UNICODE_CI, UTF8MB3_VIETNAMESE_CI |
| UTF8MB4 | UTF8MB4_0900_AI_CI, UTF8MB4_0900_AS_CI, UTF8MB4_0900_AS_CS, UTF8MB4_0900_BIN, UTF8MB4_BG_0900_AI_CI, UTF8MB4_BG_0900_AS_CS, UTF8MB4_BIN, UTF8MB4_BS_0900_AI_CI, UTF8MB4_BS_0900_AS_CS, UTF8MB4_CROATIAN_CI, UTF8MB4_CS_0900_AI_CI, UTF8MB4_CS_0900_AS_CS, UTF8MB4_CZECH_CI, UTF8MB4_DANISH_CI, UTF8MB4_DA_0900_AI_CI, UTF8MB4_DA_0900_AS_CS, UTF8MB4_DE_PB_0900_AI_CI, UTF8MB4_DE_PB_0900_AS_CS, UTF8MB4_EO_0900_AI_CI, UTF8MB4_EO_0900_AS_CS, UTF8MB4_ESPERANTO_CI, UTF8MB4_ESTONIAN_CI, UTF8MB4_ES_0900_AI_CI, UTF8MB4_ES_0900_AS_CS, UTF8MB4_ES_TRAD_0900_AI_CI, UTF8MB4_ES_TRAD_0900_AS_CS, UTF8MB4_ET_0900_AI_CI, UTF8MB4_ET_0900_AS_CS, UTF8MB4_GENERAL_CI, UTF8MB4_GERMAN2_CI, UTF8MB4_GL_0900_AI_CI, UTF8MB4_GL_0900_AS_CS, UTF8MB4_HR_0900_AI_CI, UTF8MB4_HR_0900_AS_CS, UTF8MB4_HUNGARIAN_CI, UTF8MB4_HU_0900_AI_CI, UTF8MB4_HU_0900_AS_CS, UTF8MB4_ICELANDIC_CI, UTF8MB4_IS_0900_AI_CI, UTF8MB4_IS_0900_AS_CS, UTF8MB4_JA_0900_AS_CS, UTF8MB4_JA_0900_AS_CS_KS, UTF8MB4_LATVIAN_CI, UTF8MB4_LA_0900_AI_CI, UTF8MB4_LA_0900_AS_CS, UTF8MB4_LITHUANIAN_CI, UTF8MB4_LT_0900_AI_CI, UTF8MB4_LT_0900_AS_CS, UTF8MB4_LV_0900_AI_CI, UTF8MB4_LV_0900_AS_CS, UTF8MB4_MN_CYRL_0900_AI_CI, UTF8MB4_MN_CYRL_0900_AS_CS, UTF8MB4_NB_0900_AI_CI, UTF8MB4_NB_0900_AS_CS, UTF8MB4_NN_0900_AI_CI, UTF8MB4_NN_0900_AS_CS, UTF8MB4_PERSIAN_CI, UTF8MB4_PL_0900_AI_CI, UTF8MB4_PL_0900_AS_CS, UTF8MB4_POLISH_CI, UTF8MB4_ROMANIAN_CI, UTF8MB4_ROMAN_CI, UTF8MB4_RO_0900_AI_CI, UTF8MB4_RO_0900_AS_CS, UTF8MB4_RU_0900_AI_CI, UTF8MB4_RU_0900_AS_CS, UTF8MB4_SINHALA_CI, UTF8MB4_SK_0900_AI_CI, UTF8MB4_SK_0900_AS_CS, UTF8MB4_SLOVAK_CI, UTF8MB4_SLOVENIAN_CI, UTF8MB4_SL_0900_AI_CI, UTF8MB4_SL_0900_AS_CS, UTF8MB4_SPANISH2_CI, UTF8MB4_SPANISH_CI, UTF8MB4_SR_LATN_0900_AI_CI, UTF8MB4_SR_LATN_0900_AS_CS, UTF8MB4_SV_0900_AI_CI, UTF8MB4_SV_0900_AS_CS, UTF8MB4_SWEDISH_CI, UTF8MB4_TR_0900_AI_CI, UTF8MB4_TR_0900_AS_CS, UTF8MB4_TURKISH_CI, UTF8MB4_UNICODE_520_CI, UTF8MB4_UNICODE_CI, UTF8MB4_VIETNAMESE_CI, UTF8MB4_VI_0900_AI_CI, UTF8MB4_VI_0900_AS_CS, UTF8MB4_ZH_0900_AS_CS |
Is this page helpful?