Shulou(Shulou.com)05/31 Report--

Editor to share with you what are the types of mysql data coding, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Gb2312_chinese_CI: only simplified Chinese is supported

Gb2312_BIN: and gb2312 _ bin can be said to be a subset of gb2312_chinese_ci

And gb2312_BIN is binary storage. Case sensitive

The coding format has a different meaning.

Gbk_chinese_CI supports simplified Chinese and traditional Chinese

Gbk_bin interpretation corresponds to gb2312_BIN corresponding to gbk_chinese_CI

Character set and collation list

Armscii8 (ARMSCII-8 Armenian)

Armscii8_bin Armenian, binary

Armscii8_general_ci Armenian, case-insensitive

Ascii (US ASCII)

Ascii_bin Western Europe (multilingual), binary

Ascii_general_ci Western Europe (multilingual), case-insensitive

Big5 (Big5 Traditional Chinese)

Big5_bin traditional Chinese, binary

Big5_chinese_ci traditional Chinese, case-insensitive

Binary (Binary pseudo charset)

Binary binary

Cp1250 (Windows Central European)

Cp1250_bin Central European (multilingual), binary

Cp1250_croatian_ci Croatian, case-insensitive

Cp1250_czech_cs Czech, case sensitive

Cp1250_general_ci Central European (multilingual), case-insensitive

Cp1251 (Windows Cyrillic)

Cp1251_bin Cyrillic (multilingual), binary

Cp1251_bulgarian_ci Bulgarian, case-insensitive

Cp1251_general_ci Cyrillic (multilingual), case-insensitive

Cp1251_general_cs Cyrillic (multilingual), 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 Barak (multilingual), binary

Cp1257_general_ci Barak (multilingual), case-insensitive

Cp1257_lithuanian_ci Lithuanian, case-insensitive

Cp850 (DOS West European)

Cp850_bin Western Europe (multilingual), binary

Cp850_general_ci Western Europe (multilingual), case-insensitive

Cp852 (DOS Central European)

Cp852_bin Central European (multilingual), binary

Cp852_general_ci Central European (multilingual), case-insensitive

Cp866 (DOS Russian)

Cp866_bin Russian, binary

Cp866_general_ci 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 (multilingual), binary

Dec8_swedish_ci Swedish, case-insensitive

Euckr (EUC-KR Korean)

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 Georgian, binary

Geostd8_general_ci Georgian, 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 (multilingual), binary

Hp8_english_ci English, case-insensitive

Keybcs2 (DOS Kamenicky Czech-Slovak)

Keybcs2_bin Czechoslovak, binary

Keybcs2_general_ci Czechoslovak, case-insensitive

Koi8r (KOI8-R Relcom Russian)

Koi8r_bin Russian, binary

Koi8r_general_ci 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 (multilingual), binary

Latin1_danish_ci Danish, case-insensitive

Latin1_general_ci Western Europe (multilingual), case-insensitive

Latin1_general_cs Western Europe (multilingual), case sensitive

Latin1_german1_ci German (dictionary), case-insensitive

Latin1_german2_ci German (phone book), case-insensitive

Latin1_spanish_ci Spanish, case-insensitive

Latin1_swedish_ci Swedish, case-insensitive

The above is all the content of the article "what are the types of mysql data coding?" Thank you for your reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.