csv文件导入mysql乱码解决

1. 用记事本打开csv，另存为utf-8，替换源文件

2. 在导入语句中加入  CHARACTER SET 'utf8' 

LOAD DATA LOCAL INFILE 'C:\\Users\\i-xx\\Desktop\\testservice.csv' INTO TABLE `test`.`t_channel_info` CHARACTER SET 'utf8' FIELDS ESCAPED BY '\\' TERMINATED BY '\t' LINES TERMINATED BY '\n' (`CID`, `CNAME`, `OS`, `CHANTYPE`, `PARENT_ID`, `IS_PARENT`, `CMP`, `CREATETIME`, `LEVEL`, `PRICE`, `REMARK`);