The perfect solution to the Chinese garbled problem of Mysql

The reasons why Chinese garbled characters appear in MySQL are nothing more than the following points:
1. Server itself setting problem, for example, it is still stuck at latin1
2. table language setting problem (including character and collation)
3. Client program (such as php) connection language setting problem
It is strongly recommended to use utf8!!!
utf8 is compatible with all characters in the world!!!
1. Avoid Chinese garbled characters when creating databases and tables and check the encoding method
1. When creating a database: CREATE DATABASE `test`
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';
2. When creating a table, CREATE TABLE `database_user` (
`ID` varchar(40) NOT NULL default '',
`UserID` varchar(40) NOT NULL default '',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Once these three settings are set, there will basically be no problems, that is, the same ones are used when building databases and tables. encoding format.
But if you have already built libraries and tables, you can query them in the following ways.
1. View the default encoding format:
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 |
+--------------------------+------------ -+
Note: To determine the previous two, you can use set names utf8, set names gbk to set the default encoding format;

The effect of executing SET NAMES utf8 is equivalent to setting the following at the same time:
SET character_set_client='utf8';
SET character_set_connection='utf8';
SET character_set_results='utf8';

2. View the encoding format of the test database:
mysql> show create database test;
+------------+- -------------------------------------------------- ---------------------------------------------+
| Database | Create Database |
+---------------------+-------------------------------- -------------------------------------------------- ---------------+
| test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET gbk */ |
+------------+ -------------------------------------------------- --------------------------------------------------+

3 .View the encoding format of the yjdb database:
mysql> show create table yjdb;
| yjdb | CREATE TABLE `yjdb` (
`sn` int(5) NOT NULL AUTO_INCREMENT,
`type` varchar(10) NOT NULL,
`brc` varchar(6) NOT NULL,
`teller` int(6) NOT NULL,
`telname` varchar(10) NOT NULL,
`date` int(10) NOT NULL,
`count` int(6 ) NOT NULL,
`back` int(10) NOT NULL,
PRIMARY KEY (`sn`),
UNIQUE KEY `sn` (`sn`),
UNIQUE KEY `sn_2` (`sn`)
) ENGINE =MyISAM AUTO_INCREMENT=1826 DEFAULT CHARSET=gbk ROW_FORMAT=DYNAMIC |

2. Avoid the problem of Chinese garbled characters in imported data
1: Save the data encoding format as utf-8
Set the default encoding to utf8:
set names utf8;
Set the default encoding of database db_name to utf8:
ALTER DATABASE `db_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Set the default encoding of table tb_name to utf8:
ALTER TABLE `tb_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Import:
LOAD DATA LOCAL INFILE 'C:\utf8.txt' INTO TABLE yjdb;
2: Save the data encoding format as ansi (i.e. GBK or GB2312)
Set the default encoding to gbk:
set names gbk;
Set the default encoding of database db_name to gbk:
ALTER DATABASE `db_name` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
Set table tb_name default encoding to gbk:
ALTER TABLE `tb_name` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
Import:
LOAD DATA LOCAL INFILE 'C:\gbk.tx t' INTO TABLE yjdb;

Note: 1. Do not import UTF8 into gbk, and do not import gbk into UTF8;
2. The display of UTF8 is not supported under dos;
3. Solve the problem of garbled characters in the webpage

Set the website encoding to utf-8 , which is compatible with all characters in the world.
　If the website has been running for a long time and has a lot of old data, and the Simplified Chinese settings can no longer be changed, it is recommended to set the page encoding to GBK. The difference between GBK and GB2312 is that GBK can display more characters than GB2312 , to display traditional characters in simplified code, you can only use GBK.
1. Edit /etc/my.cnf and add default_character_set=utf8 in the [mysql] section;
2. When writing the Connection URL, add the ?useUnicode=true&characterEncoding=utf-8 parameter;
3. Add it to the web page code The previous "set names utf8" or "set names gbk" command tells MySQL that all connection content must use
utf8 or gbk;