How to solve MySQL? 5.0.16 garbled Problem

Q: How can I solve the problem of MySQL 5.0.16 garbled characters?

 

A: The following method can be used to solve the garbled MySQL 5.0.16 problem:

 

 

1. Set phpMyAdmin

 

Language: Chinese simplified (zh-utf-8) MySQL Character Set: UTF-8 Unicode (utf8) MySQL connection proofread 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.

 

 

5. Add the following code:

 

$ Db-> query ("set character set gbk"); required in Linux, not in Windows.

 

This operation is equivalent to Connection Character Sets and Collations.