Solution to MySQL DATA garbled

Solution 1:

The garbled problem is simply caused by inconsistent encoding in several links when the database is written, read, and webpage files are displayed.

Garbled Problem
When writing: the encoding for writing data from the page extraction is inconsistent with that for writing data to the database.
When reading: the encoding used after reading is inconsistent with when writing data to the database.
Display: the encoding is inconsistent with the data read by the database.

Obviously, only the three are uniform: (take UTF-8 as an example)
1: The data encoding for page submission is UTF-8 (this can also be regarded as the display page encoding ),
2: Database write encoding: Alter database dB default Character Set 'utf8' collate 'utf8-General-ci ',
3: encoding used for database reading: mysql_query ("Set names 'utf8 '");
4: Display page encoding: <meta http-equiv = "Content-Type" content = "text/html, charset = UTF-8">

 
Solution 2:

Enter the MySQL command line:
Mysql> alter database you_dbname default Character Set 'utf8 ';

Mysql>Set character_set_client = 'utf8 ';
Mysql>Set character_set_connection = 'utf8'
Mysql>Set character_set_results = 'utf8'

Solution 3:

(Currently, the troubleshooting method is only applicable to MySQL 5.0.16 and other versions are not tested .)
1. Set phpMyAdmin

Language: Chinese Simplified (zh-utf-8)

MySQL Character Set: UTF-8 Unicode (utf8)

MySQL connection verification: gbk_chinese_ci

2. When creating a database

Set it to gbk_chinese_ci.

3. Create a table using SQL

Engine = MyISAM default charset = GBK;
Engine = InnoDB default charset = GBK auto_increment = 40;

4. Check table structure

The varchar (100) sorting attribute is gbk_chinese_ci.
The sorting attribute of other types is empty.

5CodeAdding

$ db-> query ("set Character Set GBK"); required in Linux, not required in Windows
This is equivalent to connection character sets and collations