distal-attribute
distal-attribute
distal-attribute
distal-attribute

import CSV not support Chinese folder and file name

User, date Message
Written by Ti9eR
2 years ago
Category: General
35 posts since Wed, 29 Feb 12
“import CSV” function not support Chinese folder and file name
Written by ansgar
2 years ago
4988 posts since Fri, 07 Apr 06
How does it look like then?
Written by Ti9eR
2 years ago
35 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
2 years ago
4988 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
2 years ago
35 posts since Wed, 29 Feb 12
The file is exist
 

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