我在本地全部用的是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, 怎样才能解决乱码问题啊
求高人指点...
/*!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, 怎样才能解决乱码问题啊
求高人指点...
character_set_connection | utf8
character_set_results | utf8 |
这3个已经是utf8了,set name的作用就是设置这3个值
,也已经设置过了
信息输出路径:server→connection→results。
所以我现在输入编码是:UTF8 - UTF8 -LATIN1;
输出编码是:LATIN1 - UTF8 -UTF8;
页面的插入和读取都没问题,就是数据库里面显示乱码。我叫虚拟主机的管理员设置下my.ini,他就会吹嘘什么他们的主机多么多么优质,还能兼容所有编码,绝对不存在配置问题...感觉TMD完全什么都不懂
今天找这方面的资料一整天,头都要爆了,来位达人解决下小弟的问题啊,临表涕零...
2、在创建数据库表时,在create table()末尾加上DEFAULT CHARSET=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 | utf8 |
| character_set_system | utf8 |
| character_sets_dir | D:\MySQL Server 5.1\share\charsets\ |
+--------------------------+-------------------------------------+
8 rows in set (0.00 sec)