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导出数据时 把"二进制区域使用十六进制显示"的勾去掉 |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 21:31 , Processed in 0.247950 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.