How to solve the garbled code problem in MySQL 5.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 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 the table structure

# The collating attribute of ##varchar(100) is gbk_chinese_ci

The collating attribute of other types is empty.

5. Add

$db->query("SET CHARACTER SET GBK");

to the code. This is required under Linux but not required under Windows.

This operation is equivalent to Connection Character Sets and Collations

The above is how to solve the garbled problem of MySQL 5.0.16. For more related content, please pay attention to PHP Chinese Net (www.php.cn)!