load data infile 导入数据 中文显示乱码 解决方法

各种字符参数统一为utf8

SET character_set_client = utf8 ; 
SET character_set_connection = utf8 ; 
SET character_set_database = utf8 ; 
SET character_set_results = utf8 ; 
SET character_set_server = utf8 ; 
SET collation_connection = utf8 ; 
SET collation_database = utf8 ; 
SET collation_server = utf8 ;

– character_set_server：默认的内部操作字符集 
– character_set_client：客户端来源数据使用的字符集 
– character_set_connection：连接层字符集 
– character_set_results：查询结果字符集 
– character_set_database：当前选中数据库的默认字符集 
– character_set_system：系统元数据(字段名等)字符集 
– 还有以collation_开头的同上面对应的变量，用来描述字符序。