mysql load data 指定编码
LOAD DATA INFILE 'E://temp//data.txt' IGNORE
INTO TABLE cell_definition_test
CHARACTER SET gbk
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n' (cgi,msc_id,title,shape_type,lon,lat,radius,angle)
原文地址:http://www.cnblogs.com/alex-blog/articles/2194519.html