| cp866 | cp866_general_ci | DOS Russian | 1 | | cp852 | cp852_general_ci | DOS Central European | 1 | | cp850 | cp850_general_ci | DOS West European | 1 | | cp1257 | cp1257_general_ci | Windows Baltic | 1 | | cp1256 | cp1256_general_ci | Windows Arabic | 1 | | cp1251 | cp1251_general_ci | Windows Cyrillic | 1 | | cp1250 | cp1250_general_ci | Windows Central European | 1 | | binary | binary | Binary pseudo charset | 1 | | big5 | big5_chinese_ci | Big5 Traditional Chinese | 2 | | ascii | ascii_general_ci | US ASCII | 1 | | armscii8 | armscii8_general_ci | ARMSCII-8 Armenian | 1 | | CHARACTER_SET_NAME | DEFAULT_COLLATE_NAME | DESCRIPTION | MAXLEN | Mysql> SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS ORDER BY CHARACTER_SET_NAME Viewing Character Sets and Proofreading Rules Settable in the Database mysql also has the character set utf8mb4, compatible with utf8, which can maintain emoji expression, but takes up one byte more than utf8. Generally, our commonly used system is named and stored data d system in Chinese and English, so the server and mysql database are coded as utf8. The default of linux system is utf-8 encoding, while the default of windows is gbk encoding. There are many kinds of character sets in database. So to solve the problem of scrambling code, we should understand the reason: the coding of client connection settings is inconsistent with table coding! The most common problem is that the database insert view or import and export has been scrambled, which should have happened to all people who have used mysql.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |