import CSV not support Chinese folder and file name

Ti9eR's profile image Ti9eR posted 11 years ago in General Permalink
“import CSV” function not support Chinese folder and file name
ansgar's profile image ansgar posted 11 years ago Permalink
How does it look like then?
Ti9eR's profile image Ti9eR posted 11 years ago Permalink
LOAD DATA LOW_PRIORITY LOCAL INFILE 'D:\\用户数据\\Administrator\\桌面\\测试.csv' REPLACE INTO TABLE `testdb`.`info` CHARACTER SET gbk FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (`billcertino`, `identitytype`, `saledate`, `saletime`, `trantype`, `stateflag`);
/* SQL Error (2): File 'D:\用户数据\Administrator\桌面\测试.csv' not found (Errcode: 2) */
ansgar's profile image ansgar posted 11 years ago Permalink
Ok... I guess you already checked if that file really exists. So, I have no clue, apart from suspecting libmysql.dll which may have problems with Unicode characters in a file path.
Ti9eR's profile image Ti9eR posted 11 years ago Permalink
The file is exist

Please login to leave a reply, or register at first.