NOTE: Generally, 3 places - (1) When creating a database, you should include character set; (2) In head section of html code of a web page, you should define character set; (3) after mysql_select_db, you should include mysql_query("set names gbk;"). That is all.
(1) In the file 'my.ini', add the following two lines:
[client]
default-character-set=gbk
[mysqld]
character-set-server=gbk
Restarted MySQL server.
(2) When creating a database, use -
create database [database name] character set 'gbk' collate 'gbk_chinese_ci';
(3) Run the command 'show create table ...'.
mysql>show create table [table name];
Check what the default default charset is.
If it is not 'gbk', change it into 'gbk'.
The method is -
create table if not exists '[table name]' (
...
) engine=InnoDB default charset=gbk;
(4) In the PHP page, after the statement -
mysql_select_db("dbname", $db);
Add the following statement -
mysql_query("set names gbk;");
After the above 3 actions, Chinese will be displayed.
