Solve the Problem of MySQL Chinese garbled characters

Solve the Problem of MySQL Chinese garbled characters

In the case of MySQL Chinese garbled characters, first use the status command to check the database configuration, as shown below:

The information about the database configuration is displayed.

You can also use show create database XXX to display the encoding settings when creating a database.

Generally, you need to specify the encoding method of the database when creating the database, and utf8 when there is a Chinese character.

The creation method is as follows. The default encoding method of the database is utf8. However, the following error may occur:

Incorrect string value: '\ xB1 \ xB1 \ xBE \ xA9' for column 'B';

Check the script format you used to create the database. If it is notepad, the default character encoding format is ANSI, so to save again in the UTF-8, you can.

At this time, the jdbc program should be able to read successfully, but the console will display

In this case, you need to enter the following command:

Set character_set_results = 'gb2312 (or gbk )';

You can see it normally.

2. Create database commands using scripts

> Source file path \ file name. SQL

This article permanently updates the link address: