Solution to the problem that MySQL in Windows system cannot input and display Chinese

Step 1: Use Notepad to open the "my.ini" file in the MySQL installation directory.

# MySQL client library initialization.
[client]
port=3306
[mysql]
default-character-set=utf8

Check if default-character-set is utf8, if not, just change it to utf8! (Previous versions may not have this sentence, so just add it!)

Step 2: Enter in the MySQL database cmd: show variables like'%char% ';

This is what it looks like after successful setup.

Step 3:

set character_set_database=utf8;
set character_set_server=utf8;
set character_set_client=gbk;
set character_set_connection=gbk;

This is the configuration to insert Chinese characters. You must enter these commands in cmd to run mysql.

Step 4:

set character_set_results=gbk

This is the configuration to display Chinese. Done

Next, I will share a graphic operation method

#Solve the problem that mysql cannot input Chinese characters

Modify the mysql character set and modify the configuration file my.ini
character_set_server = utf8
Centered image:

2.

We have already established the database, and now we also need to change the database character set in Navicat for MySQL. Right-click the database and select Database Properties, as shown in the figure. After entering, change the character set to utf8

3. You also need to right-click each table and select the involved table;

Then in "Options", modify the character set of the table.

4.

Enter the design table, click on a field, and find that the data type is still Latin1. OK, just change it one by one.

5. It’s done perfectly, you can try it now.

Summarize

The above is the solution to the problem that MySQL on the window system cannot input or display Chinese. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time!