Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to deal with the question mark displayed in Chinese in mysql. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

The solution to the question mark shown in Chinese in mysql is: 1, open the my.ini configuration file; 2, add [character-set-server=utf8] under the mysqld node to save the file; 3, restart mysql.

First open the my.ini configuration file

Then modify it in my.ini as follows

Add paragraphs [mydqld] and [client]

Default-character-set=utf8 (some versions do not support default-character-set=utf8, just use character_set_server=utf8 instead of default-character-set=utf8)

If there is no [client], manually add the [client] paragraph.

[1] add it under the [client] node (if this is another character_set_server=utf8 that writes mine in this way, it will report an error of 1067 [mysql service cannot be started], you can try) (this is the client's coding configuration)

Default-character-set=utf8

[2] add (this is the server-side coded configuration) under the [mysqld] node (Note: collation is the sorting method)

Character-set-server=utf8collation-server=utf8_general_ci

Finally, restart mysql.

This is enough about how to deal with the question mark in Chinese in mysql. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

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.