Solution to the garbled code problem in MySQL 5.x
|
MySQL is a commonly used open source database software, but it does not seem to be very friendly to first-time users. The default character set in MySQL5.x version is latin1, which is the ISO-8859-1 character set we know. This character set encoding does not include Chinese characters, so when we use it, Chinese characters will appear garbled. This can be solved by modifying the database default character set. Enter the MySQL command line: mysql> show variables like '%colla%'; +----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | gbk_chinese_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | +----------------------+-------------------+ 3 rows in set, 1 warning (0.00 sec) mysql> show variables like '%char%'; +--------------------------+---------------------------------------------------------+ | Variable_name | Value | +--------------------------+---------------------------------------------------------+ | character_set_client | gbk | | character_set_connection | gbk | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | gbk | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.7\share\charsets\ | +--------------------------+---------------------------------------------------------+ 8 rows in set, 1 warning (0.00 sec) You can see that the default character set is now latin1 Find the MySQL configuration file. The configuration file in Windows is my.ini. My computer is located at C:\ProgramData\MySQL\MySQL Server 5.7. The file that needs to be modified in Linux is my.conf. The specific path depends on your actual installation location. Modify the configuration in the following nodes respectively: The configuration of the [client] node in the 5.7 I use needs to be added, and the other two nodes [mysql] and [mysql] need to open the comments and change them to utf8. [client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysql] character_set_server=utf8 Then restart MySQL
Check the character set again, all have been changed to utf8 character set mysql> show variables like '%colla%'; +----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | gbk_chinese_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +----------------------+-----------------+ 3 rows in set, 1 warning (0.00 sec) mysql> show variables like '%char%'; +--------------------------+---------------------------------------------------------+ | Variable_name | Value | +--------------------------+---------------------------------------------------------+ | character_set_client | gbk | | character_set_connection | gbk | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | gbk | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.7\share\charsets\ | +--------------------------+---------------------------------------------------------+ 8 rows in set, 1 warning (0.00 sec) To ensure encoding consistency, you can also specify the character set when creating a database or table, and specify the connection parameters after the connection string: ?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: Vue implements the sample code of adding, deleting, modifying and checking the tree structure
>>: Detailed explanation of Docker Swarm concepts and usage
Recommend
Detailed explanation of Vue-router nested routing
Table of contents step 1. Configure routing rules...
Explain how to analyze SQL efficiency
The Explain command is the first recommended comm...
vitrualBox+ubuntu16.04 install python3.6 latest tutorial and detailed steps
Because I need to use Ubuntu+Python 3.6 version t...
How to use Vue3 asynchronous data loading component suspense
Table of contents Preface Creating Components Sum...
How to deploy tomcat in batches with ansible
1.1 Building the Directory Structure This operati...
Why does MySQL paging become slower and slower when using limit?
Table of contents 1. Test experiment 2. Performan...
Detailed explanation of the spacing problem between img tags
IMG tag basic analysis In HTML5, the img tag has ...
A brief analysis of Docker private image library and Alibaba Cloud object storage OSS
Docker private image library Docker private image...
Detailed steps to install MySql 5.7.21 in Linux
Preface The most widely used database in Linux is...
Detailed explanation of Nginx's control over access volume
Purpose Understand the Nginx ngx_http_limit_conn_...
How to choose transaction isolation level in MySQL project
introduction Let's start with our content. I ...
How to use Docker+DockerCompose to encapsulate web applications
Table of contents Technology Stack Backend build ...
In-depth understanding of the creation and implementation of servlets in tomcat
1. What is a servlet 1.1. Explain in official wor...
How to optimize MySQL query speed
In the previous chapters, we introduced how to ch...
Detailed explanation of the update command for software (library) under Linux
When installing packages on an Ubuntu server, you...