PolarDB:Supported character sets

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.

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.

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.

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 and 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 and GBK_CHINESE_CI.

GEOSTD8

GEOSTD8_BIN, GEOSTD8_GENERAL_CI.

GREEK

GREEK_BIN an

HEBREW

HEBREW_BIN and 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 and MACCE_GENERAL_CI.

MACROMAN

MACROMAN_BIN, MACROMAN_GENERAL_CI.

SJIS

SJIS_BIN and 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.