import CSV not support Chinese folder and file name
| User, date | Message |
|---|---|
|
Written by Ti9eR
5 months ago Category: General 21 posts since Wed, 29 Feb 12 |
“import CSV” function not support Chinese folder and file name |
|
Written by ansgar
5 months ago 3950 posts since Fri, 07 Apr 06 |
How does it look like then? |
|
Written by Ti9eR
5 months ago 21 posts since Wed, 29 Feb 12 |
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) */ |
|
Written by ansgar
5 months ago 3950 posts since Fri, 07 Apr 06 |
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. |
|
Written by Ti9eR
5 months ago 21 posts since Wed, 29 Feb 12 |
The file is exist |
|
Please login to leave a reply, or register at first. |