Description of mysql Data Encoding types

Gb2312_chinese_CI: Only simplified Chinese characters are supported.

Gb2312_BIN: While gb2312_bin is a subset of gb2312_chinese_ci,

And gb2312_BIN is binary storage. Case Sensitive

The database encoding format has different meanings.

Gbk_chinese_CI supports Simplified Chinese and Traditional Chinese

Gbk_bin: gbk_chinese_CI corresponding to gb2312_BIN

Mysql Character Set and collation list

Armscii8 (ARMSCII-8 Armenian)
Armscii8_bin Armenia, binary
Armscii8_general_ci Armenia, case insensitive
Ascii (us ascii)
Ascii_bin Western Europe (multi-language), binary
Ascii_general_ci Western Europe (multi-language), case insensitive
Big5 (Big5 Traditional Chinese)
Big5_bin traditional Chinese, binary
Big5_chinese_ci traditional Chinese, case insensitive
Binary (Binary pseudo charset)
Binary
Cp1250 (Windows Central European)
Cp1250_bin Central Europe (multi-language), binary
Cp1250_croatian_ci slang, case insensitive
Cp1250_czech_cs Czech, case sensitive
Cp1250_general_ci Central Europe (multi-language), case insensitive
Cp1251 (Windows Cyrillic)
Cp1251_bin Spanish (multi-language), binary
Cp1251_bulgarian_ci, not case sensitive
Cp1251_general_ci Spanish (multi-language), case insensitive
Cp1251_general_cs Spanish (multi-language), case sensitive
Cp1251_ukrainian_ci Ukrainian, case insensitive
Cp1256 (Windows Arabic)
Cp1256_bin Arabic, binary
Cp1256_general_ci Arabic, case insensitive
Cp1257 (Windows Baltic)
Cp1257_bin Library (multi-language), binary
Cp1257_general_ci (multi-language), case insensitive
Cp1257_lithuanian_ci Lithuania, case insensitive
Cp850 (DOS West European)
Cp850_bin Western Europe (multi-language), binary
Cp850_general_ci Western Europe (multi-language), case insensitive
Cp852 (DOS Central European)
Cp852_bin Central Europe (multi-language), binary
Cp852_general_ci Central Europe (multi-language), case insensitive
Cp866 (DOS Russian)
Cp866_bin Russian, binary
Cp866_general_ci in Russian, case insensitive
Cp932 (SJIS for Windows Japanese)
Cp932_bin Japanese, binary
Cp932_japanese_ci Japanese, case insensitive
Dec8 (DEC West European)
Dec8_bin Western Europe (multi-language), binary
Dec8_swedish_ci Swedish, case insensitive
Euckr (EUC-KR)
Euckr_bin Korean, binary
Euckr_korean_ci (Korean), case insensitive
Gb2312 (GB2312 Simplified Chinese)
Gb2312_bin Simplified Chinese, binary
Gb2312_chinese_ci (Simplified Chinese), case insensitive
Gbk (GBK Simplified Chinese)
Gbk_bin Simplified Chinese, binary
Gbk_chinese_ci (Simplified Chinese), case insensitive
Geostd8 (GEOSTD8 Georgian)
Geostd8_bin Georgia, binary
Geostd8_general_ci Georgia, case insensitive
Greek (ISO 8859-7 Greek)
Greek_bin Greek, binary
Greek_general_ci Greek, case-insensitive
Hebrew (ISO 8859-8 Hebrew)
Hebrew_bin Hebrew, binary
Hebrew_general_ci Hebrew, case insensitive
Hp8 (HP West European)
Hp8_bin Western Europe (multi-language), binary
Hp8_english_ci English, case insensitive
Keybcs2 (DOS Kamenicky Czech-Slovak)
Keybcs2_bin Czech Slovak, binary
Keybcs2_general_ci in the Czech Republic, case insensitive
Koi8r (KOI8-R Relcom Russian)
Koi8r_bin Russian, binary
Koi8r_general_ci in Russian, case insensitive
Koi8u (KOI8-U Ukrainian)
Koi8u_bin Ukrainian, binary
Koi8u_general_ci Ukrainian, case insensitive
Latin1 (cp1252 West European)
Latin1_bin Western Europe (multi-language), binary
Latin1_danish_ci Danish, case insensitive
Latin1_general_ci Western Europe (multi-language), case insensitive
Latin1_general_cs Western Europe (multi-language), case sensitive
Latinw.germanw.ci (dictionary), case insensitive
Latinstmgerman2_ci German (Phone Book), case insensitive
Latin?spanish_ci Spanish, case insensitive
Latin1_swedish_ci Swedish, case insensitive