1.my.ini: [mysql] default-character-set=utf8 [mysqld] 飞飞Asp技术乐.园default-character-set=utf8 default-storage-engine=MyISAM 飞飞Asp技术乐!园在[mysqld]下加入: default-collation=utf8_bin init_c 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导出数据时 把"二进制区域使用十六进制显示"的勾去掉
|