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

This article mainly introduces the Windows10 mysql5.5 database command line Chinese garbled code how to do, the article is very detailed, has a certain reference value, interested friends must read it!

Open the my.ini file in the installation directory

Mine is: C:\ Program Files\ MySQL\ MySQL Server 5.5.The modifications are as follows:

[client] default-character-set=utf8port=3306 [mysql] # many of the answers to the following gbk on the Internet are also set to utf8, and the result is garbled default-character-set=gbk# SERVER SECTION#-# # The following options will be read by the MySQL Server. Make sure that# you have installed the server correctly (see above) so it reads this # file.# [mysqld] # The TCP/IP Port the MySQL Server will listen onport=3306#Path to installation directory. All paths are usually resolved relative to this.basedir= "C:/Program Files/MySQL/MySQL Server 5.5 /" # Path to the database rootdatadir= "C:/ProgramData/MySQL/MySQL Server 5.5/Data/" # The default character set that will be used when a new schema or table is# created and no character set is definedcharacter-set-server=utf8collation-server=utf8_general_ci restart mysql after modification, check the code: mysql > show variables like 'character_set%' +-+ | Variable_name | Value | +-- +- -+ | character_set_client | gbk | | character_set_connection | gbk | | character_set_database | utf8 | | character_set_filesystem | | character_set_results | gbk | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | C :\ Program Files\ MySQL\ MySQL Server 5.5\ share\ charsets\ | try the +-+ operation: mysql > insert into per values ('garbled resolution') Query OK, 1 row affected (0.00 sec) mysql > select * from per;+-+ | name | +-+ | one after another | | garbled resolution | +-+ 3 rows in set (0.00 sec) above is all about how to garble Chinese characters on the command line of mysql5.5 database under Windows10. Thank you for your reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.