我有一个包含30万行的file.csv文件,其中许多行都是外国城市的名称,并带有重音字符。当我尝试在mysql中进行导入时,该字段会发出警告,并且在特殊字符处截断该字段。
LOAD DATA LOCAL INFILE '/var/tmp/geoip/location.csv' INTO TABLE Geolocation2 FIELDS TERMINATED BY ',' enclosed by '"' LINES TERMINATED BY '\n' (id, country, region, city, postalCode, latitude, longitude, metrocode, areacode );