PolarDB分布式版支持的字符集

字符集

排序规则

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。

字符集

排序规则

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。

字符集

排序规则

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。

字符集

排序规则

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。