mysql导入文件中文乱码怎么办
发布时间：12/01 来源：未知 浏览：
关键词：
mysql导入文件中文乱码的解决方法：第一新建数据库并拟定编码；然后在导入数据库文件以前，拟定编码set names utf8即可。
改完后也不看了，直接插数据试试：
insert into book (id,bookname,size,price) values (1,"测试",2,3) ;
插入成功，查看数据是不是还中文乱码，发明并稳定码了：
那么开端进行下一步，输出sql文件，进入到mysql的bin名目下，开端通过下令输出，这个历程需要输入密码
E:\mysql-5.7.28-winx64\bin>mysqldump -u root -p test > test.sql Enter password: *******
输出的文件，表的编码格局utf8，与以前导入文件的比拼并看不出什么题目。
那么，就是以前导入文件的历程，新建数据库的历程除了题目，查看以前导入的mydb.sql 的mydb数据库构造，公然不合错误：
mysql> use mydb; Database changed mysql> show variables like 'character_set_database'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | character_set_database | latin1 | +------------------------+--------+ 1 row in set, 1 warning (0.00 sec)
遂修改之：alert database mydb character set utf8;
然后再查看表的编码，发明有鬼：
mysql> show create table sp_user_cart; +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | sp_user_cart | CREATE TABLE `sp_user_cart` ( `cart_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', `user_id` int(11) unsigned NOT NULL COMMENT '瀛﹀憳id', `cart_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '璐?墿杞﹁?鎯呬俊鎭?紝浜岀淮鏁扮粍搴忓垪鍖栦俊鎭', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `delete_time` timestamp NULL DEFAULT NULL, PRIMARY KEY (`cart_id`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8
utf8mb4_unicode_ci 这个东西是怎么出来的...
然后改了编码，查询，还是不合错误，想起来以前新建数据库，可能是忘怀设定编码，导入的东西原来就乱码了，也或者是my.ini配置不合错误，从头开端用准确流程试试吧。
先查看数据库的编码设定:show variables like 'character%';
发明很凌乱：
mysql> show variables like 'character%'; +--------------------------+----------------------------------------+ | Variable_name | Value | +--------------------------+----------------------------------------+ | character_set_client | gbk | | character_set_connection | gbk | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | gbk | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | D:\mysql-5.7.29-winx64\share\charsets\ | +--------------------------+----------------------------------------+
开端改，通过一系列的setset character_set_client = utf8;
得到效果
+--------------------------+----------------------------------------+ | Variable_name | Value | +--------------------------+----------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | utf8 | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | D:\mysql-5.7.29-winx64\share\charsets\ | +--------------------------+----------------------------------------+
新建数据库并拟定编码：CREATE DATABASE test2 CHARACTER SET utf8 COLLATE utf8_general_ci;
运用：use test2
在导入数据库文件以前，拟定编码set names utf8;
导入：source F:xxxx\xxxx\mydb.sql;
不算漫长的期待之后，查询，稳定码了
mysql> select * from sp_role;
+---------+---------------+---------------------------------------------------------------------------------------------
------------------------------------------------------+-----------------------------------------------------------------
------------------------+--------------------+
| role_id | role_name | ps_ids
| ps_ca
| role_desc |
+---------+---------------+---------------------------------------------------------------------------------------------
------------------------------------------------------+-----------------------------------------------------------------
------------------------+--------------------+
| 30 | 主管 | 101,0,104,116,115,142,143,144,121,122,123,149,102,107,109,103,111,129,130,134,135,138,139,14
0,141,112,147,125,110,131,132,133,136,137,145,146,148 | Goods-index,Goods-tianjia,Category-index,Order-showlist,Brand-in
dex | 技术负责人 |
| 31 | 测试角色 | 101,0,104,105,116,117,115,142,143,144,121,122,123,149,103,111,129,134,138,112,147
| Goods-showlist,Goods-tianjia,Category-showlist,Order-showlist,Or
der-dayin,Order-tianjia | 测试角色描述 |
| 34 | 测试角色2 | 0,105,116,142,143,122
| NULL
| 测试描述12 |
| 39 | 大发送到 | 101,0,104,105,116
| NULL
| 阿斯蒂芬 |
| 40 | test | 102,0,107,109,154,155,145,146,148
| NULL实战项目可以继续进行，遂生法喜。
以上就是mysql导入文件中文乱码怎么办的细致内容，更多请关注 百分百源码网 其它相干文章！
