What are the types of mysql data coding collation?
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!
