サポートされている文字セット - PolarDB - Alibaba Cloud ドキュメントセンター

このトピックでは、PolarDB-X でサポートされている文字セットについて説明します。

Enterprise Edition

MySQL 5.7

文字セット	照合順序
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

文字セット	照合順序
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

文字セット	照合順序
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

文字セット	照合順序
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。