mysql source导入报错ERROR 1366的解决方法

文件是utf8的,数据库表是utf8的,为什么客户端导入会报错呢?

发现客户端用的是gbk的

改为utf8后正常

SHOW VARIABLES LIKE 'character%';

+--------------------------+---------
-----+
| 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
     |

 set character_set_client=utf8;

d:
cd D:"Program Files"MySQL"MySQL Server 5.7"in
mysql -h127.0.0.1 -uroot -p
tee  E:output.log
set character_set_client=utf8;
source E:CUST_ORG_PROFILE_2.sql
原文地址:https://www.cnblogs.com/castlevania/p/6198150.html