导入数据之后,中文部分出现乱码,如何解决呢?
网上看了几个例子,不是很明白,照着做了,没有成功。
网上看了几个例子,不是很明白,照着做了,没有成功。
解决方案 »
- mysql查询慢
- 如何快速确定记录是否存在?
- mysql中基础问题
- 我想用mysql.h头文件中的函数联接数据库,安装后却没发现mysql.h在哪里?请高手指教
- 竟然有这么诡异的问题,研究了半个月头都大了,100分,帮我解释下啊大家
- mysql如何做出像ms-sql的计划备份的功能?
- 安装mysql到d:\mysql,为什么连接不上?
- 请高手帮忙我得这条sql语句???
- INSERT INTO 'order' (id,pid,cid,state) VALUES (NULL, '6','crew1','work in progre
- MySQL表中每一条数据都有几个标签字段(比如:tag1,tag2,tag3)应该如何查询具体的一条?
- 数据库转存出错
- mysql中复制表数据提示报错
use lookdb;
source D:/MYSQL/kext.sql;这样错了吗?我想导入进去的是gbk格式,有什么办法吗?
估计是字符集的问题
| Variable_name | Value
+------------------------------------------------------------
| character_set_client | latin1
| character_set_connection | latin1
| character_Set_database | latin1
| character_set_filesystem | binary
| character_set_results | latin1
| character_set_server | latin1
| character_set_system | utf8
| character_sets_dir | D:\APMServ5.2.6\MySQL5.1\share\charsets
+-------------------------------------------------------------
8 rows in set(0.00 sec)
set names gbk;
use lookdb;
source D:/MYSQL/kext.sql;
set names utf8
or
my.ini[mysql]default-character-set=utf8重新启动服务器
在新的字符集下重新建表、插入记录
MySQL 中文显示乱码
|Table|Create Table
+------------+----------------------------
|text |Create Table 'text' (
'old_id' int(8) not null,
'old_text' mediumtext character set gbk collate utf8_unicode_ci not null,
'old_flags' tinyblob not null
)engine=MyIsam DEFAULT = gbk|
+------------+----------------------------
1 row in set(0.00 sec)
mysql>show full columns from text;+------------+----------------------------
|Field|Type|Collation|null|key|default|Extra|Privileges
+------------+----------------------------
|Old_id|int(8)|null|No||null||select,insert,update,references|||Old_text| mediumtext|utf8_unicode_ci|No||null|select,insert,update,references|||Old_flags|tinyblob|null|no||null|select,insert,update,references||
+------------+----------------------------
3 rows in set (0.00 sec)
mysql>show variables like 'char%';+------------+----------------------------
|Variable_name |value
+------------+----------------------------
|character_set_client |latin1
|character_set_connection|latin1
|character_set_database |gbk
|character_set_fiesystem |binary
|character_set_results |latin1
|character_set_server |latin1
|character_set_system |utf8
|character_set_dir |D:\APMServ5.2.6\MySQL5.1\share\characters\
+------------+-----------------------------
rows in set(0.00 sec)mysql>
| Variable_name | Value |
+--------------------------+--------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | utf8 |
| character_set_system | utf8 |
+--------------------------+--------+就ok了,如果不是上述的编码,请修改mysql的配置文件:my.ini
把[mysql]下的编码改为gbk(如果 不是gbk的话),即
default-character-set=gbk
把[mysqld]下的编码改为utf8:
default-character-set=utf8
然后重建数据库和表,就ok了。
+------------+----------------------------
|Table|Create Table
+------------+----------------------------
|text |Create Table 'text' (
'old_id' int(8) not null,
'old_text' mediumtext character set latin1 not null,
'old_flags' tinyblob not null
)engine=MyIsam DEFAULT = gbk|
+------------+----------------------------
1 row in set(0.00 sec)
mysql>show full columns from text;
+------------+----------------------------
|Field|Type|Collation|null|key|default|Extra|Privileges|Comment|
+------------+----------------------------
|Old_id|int(8) unsigned|null|No||null||select,insert,update,references|||Old_text| mediumtext|latin1_swedish_ci|No||null|select,insert,update,references|||Old_flags|tinyblob|null|no||null|select,insert,update,references||
+------------+----------------------------
3 rows in set (0.00 sec)
mysql>show variables like 'char%';
+------------+----------------------------
|Variable_name |value
+------------+----------------------------
|character_set_client |gbk
|character_set_connection|gbk
|character_set_database |gbk
|character_set_fiesystem |binary
|character_set_results |gbk
|character_set_server |latin1
|character_set_system |utf8
|character_set_dir |D:\APMServ5.2.6\MySQL5.1\share\characters\
+------------+-----------------------------
8 rows in set(0.00 sec)
latin1_swedish_ci.