中文:
set names gbk;
set character_set_database=gbk;
set character_set_server=utf8;
网页编码设置
php设置 header("Content-type: text/html; charset=gbk");
静态网页设置 <meta http-equiv="Content-Type" content="text/html;charset=gbk">
默认数据库引擎修改 my.ini:
[mysqld]
default-storage-engine=INNODB