How to solve the garbled problem of MySQL 5.0.16

Q: How to solve the MySQL 5.0.16 garbled problem?

A: MySQL 5.0.16 garbled problem can be solved in the following way:

<>< p=""><>

1. Set phpMyAdmin

Language:chinese Simplified (zh-utf-8)

MySQL Character Set: UTF-8 Unicode (UTF8)

MySQL Connection Proofing Gbk_chinese_ci

2. When creating a database

Organize and set into Gbk_chinese_ci

3. Create a table with SQL

Engine=myisam DEFAULT CHARSET=GBK;

Engine=innodb DEFAULT CHARSET=GBK auto_increment=40;

4. Check the table structure

The collation property of varchar (100) is Gbk_chinese_ci

Other types of collation properties are empty.

5. Add in the Code

$db->query ("Set CHARACTER set GBK"); Linux is required, not required under Windows.

This operation is equivalent to connection Character Sets and collations