1.my.ini:
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
default-storage-engine=myisam
在[mysqld]下加入:
default-collation=utf8_bin
init_connect='set names utf8'
2.在需要做数据库操作的php程序前面加上
mb_internal_encoding('utf-8');
3.create table最后边加上engine=myisam default charset=utf8 collate=utf8_bin
4.phpmyadmin/config.inc.php
$cfg['defaultcharset'] = 'utf-8';
$cfg['recodingengine'] = 'iconv';
5.phpmyadmin/libraries/string.lib.php
将第41行的
mb_internal_encoding($globals['charset']);
改为：mb_internal_encoding('utf-8');
6.phpadmin导出数据时
把二进制区域使用十六进制显示的勾去掉