Mysql table does not display Chinese, what should I do if there are garbled characters?

Mysql table does not display Chinese, garbled solution: first check the encoding method of the database; then edit and open the my.ini file; then modify the content to “default-character-set=utf8”; finally restart the database That’s it. The various character settings above must be consistent, but simply setting the encoding format for the database and data table cannot completely solve the problem of garbled characters. I will say the above There is a problem of garbled characters that is solved after setting all character encodings to utf8. Explain the above information: | character_set_client: The character set (encoding method) of the data requested by the client | character_set_connection: Receive data from the client, and then transmit the character set (the encoding used to establish the connection) | character_set_database: The character set of the default database, no matter how the default database is changed, it is this character set; if there is no default database, then use the character set specified by character_set_server, This variable is recommended to be managed by the system itself, not manually defined. | character_set_results: the character set of the result set | character_set_server: The default character set of the database server | character_set_system: This value is always utf8 and…

Contact Us

Contact us

181-3619-1160

Online consultation: QQ交谈

E-mail: [email protected]

Working hours: Monday to Friday, 9:00-17:30, holidays off

Follow wechat
Scan wechat and follow us

Scan wechat and follow us

Follow Weibo
Back to top
首页
微信
电话
搜索