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

How to view the character set in mysql? for this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

(1) the easiest way to modify is to modify the key values of the character set in the my.ini file of mysql.

For example, default-character-set = utf8

Character_set_server = utf8

After modification, restart the mysql service, service mysql restart

Use mysql > SHOW VARIABLES LIKE 'character%'; to view, and find that the database codes have been changed to utf8

+-- +-- + | Variable_name | Value | +-- -+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | character_set_system | utf8 | | character_sets_dir | D: "mysql-5.0.37" share "charsets" | +- -+

(2) another way to modify the default character set of mysql is to use the command of mysql

Mysql > SET character_set_client = utf8; mysql > SET character_set_connection = utf8; mysql > SET character_set_database = utf8; mysql > SET character_set_results = utf8; mysql > SET character_set_server = utf8; mysql > SET collation_connection = utf8; mysql > SET collation_database = utf8; mysql > SET collation_server = utf8

In general, even if the mysql default character set of the table is set to utf8 and the query is sent through UTF-8 encoding, you will find that the code stored in the database is still garbled. The problem lies in this connection connection layer. The solution is to execute the following sentence before sending the query:

SET NAMES 'utf8'

It is equivalent to the following three instructions:

SET character_set_client = utf8; SET character_set_results = utf8; SET character_set_connection = utf8; this is the answer to the question about how to view the character set in mysql. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.