mysql导入1366_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 Server5.7"\bin

mysql-h127.0.0.1 -uroot -p

tee E:\output.log

set character_set_client=utf8;

source E:\CUST_ORG_PROFILE_2.sql