1.数据库编码
ALTER DATABASE 'test' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
2.表category的编码该为utf8
ALTER TABLE 'category' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
3.修改字段的编码：
ALTER TABLE 'test' CHANGE 'dd' 'dd' VARCHAR( 45 ) CHARACTER
SET utf8 COLLATE utf8_bin NOT NULL
4.在连接数据库的语句中
mysql_connect('localhost','user','password');
mysql_select_db('my_db');
mysql_query("set names utf8;"); //select 数据库之后加多这一句
5.PHP页面开始第一句
header("content-type:text/html; charset=utf-8");