How to solve the mysql insert garbled problem

Problem description:

When inserting Chinese characters into MySQL, or Chinese characters are displayed normally in MySQL, but jsp displays Chinese characters in MySQL in the foreground, it is garbled.

Solution:

Enter the mysql console and execute the following command:

SET character_set_client='utf8';
SET character_set_connection='utf8';
SET character_set_results='utf8';

More solutions:

The CMD client input uses GBK encoding, while the database encoding format is UTF-8. The inconsistent encoding results in garbled characters. The current encoding format of the CMD client cannot be modified, so you can only modify the encoding set of connection, client, and results to inform the server that the currently inserted data uses GBK encoding. Although the server database uses UTF-8 encoding, it can recognize the GBK encoded data notified to the server and automatically convert it to UTF-8 for storage. You can use the following statement to quickly set the encoding set related to the client:
set names gbk;

After the settings are completed, the garbled problem of data inserted or displayed on the client can be solved, but we will soon find that this form of setting is only valid in the current window. When the window is closed and the CMD client is reopened, the garbled problem will appear again; so, how to make a once-and-for-all setting? There is a my.ini configuration file in the MySQL installation directory. By modifying this configuration file, the garbled character problem can be solved once and for all. In this configuration file, [mysql] is related to the client configuration, and [mysqld] is related to the server configuration. The default configuration is as follows:

[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8

At this time, you only need to change the default encoding default-character-set=utf8 to default-character-set=gbk and restart the MySQL service.

This is the end of this article on how to solve the MySQL insert garbled problem. For more information on how to solve the MySQL insert garbled problem, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!