Troubleshooting of garbled MySQL 5.0.16

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.

Trackback: http://tb.blog.csdn.net/TrackBack.aspx? Postid = 536707