+ -
当前位置:首页 → 问答吧 → mysql乱码问题求助~~~

mysql乱码问题求助~~~

时间:2011-06-30

来源:互联网

我在本地全部用的是utf-8格式,测试也完全正常,但是导出数据库文件后必须要删除下面几行
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
才能导入到空间的数据库,这样空间数据库就出现乱码了,我查询空间数据库的编码的结果:
mysql> show variables like '%char%';
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
8 rows in set

只有character_set_server | latin1 编码是错的,可是怎么改也改不成utf8, 又没有权限修改my.ini, 怎样才能解决乱码问题啊
求高人指点...

作者: b2812787   发布时间: 2011-06-30

mysql --default-character-set dbname < xx.sql

作者: rucypli   发布时间: 2011-06-30

set names 'utf8';

作者: ACMAIN_CHM   发布时间: 2011-06-30

相关阅读 更多