Solution to the garbled code problem of MySQL5.0.16

[Introduction] Question: How to solve the garbled problem of MySQL 5 0 16? Answer: The garbled code problem of MySQL 5 0 16 can be solved by the following method: 1 Set phpMyAdmin Language: Chinese simplified (zh-utf-8) MySQL character set: UTF-8 Unicode (utf8) MySQL

Q: How to solve the garbled code problem in MySQL 5.0.16?

Answer: The garbled code problem in MySQL 5.0.16 can be solved by the following method:

1. Set up phpMyAdmin

Language:Chinese simplified (zh-utf- 8)

MySQL character set: UTF-8 Unicode (utf8)

MySQL connection proofreading gbk_chinese_ci

2. When creating the database

Organize and set it to gbk_chinese_ci

3. Use SQL to create the table

ENGINE=MyISAM DEFAULT CHARSET=gbk;

ENGINE= InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=40 ;

4. Check that the sorting attribute of

varchar(100) in the table structure is gbk_chinese_ci

The finishing attributes of other types are empty.

5. Add

$db->query("SET CHARACTER SET GBK"); in the code. It is required under Linux, but not under Windows. need.

This operation is equivalent to Connection Character Sets and Collations

The above is the detailed content of Solution to the garbled code problem of MySQL5.0.16. For more information, please follow other related articles on the PHP Chinese website!