Load data infile (data erroneous) with version 3.55.0.21

rollo mickael · Post by **rollo mickael** » Tue 27 Sep 2005 14:31

Hi
we have some problem whith the LOAD DATA LOCAL INFILE function. The query doesn't do the good result.

The query is :

LOAD DATA LOCAL INFILE 'C:\delphi7\sources\neoscope2\FILES\IMPORTFILES\temp.txt' INTO TABLE imptempo FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (nom,prenom)

Content of Temp.txt :

"marchand";"mickael"
"poireau";""
"hubert";""

The result in the first field nom is (instead of "marchand"):

delphi7sources
eoscope2FILESIMPORTFILES emp.txt"ma

Config:
Server : MySQL 4.1.9
Developement : Delphi 7 + Mydac 3.55.0.21

But in version 3.00.1.3 this query return the good result.
Also, the command line client and the mysqlimport utility are OK.

Do you reproduce this problem ?

Ikar · Post by **Ikar** » Wed 28 Sep 2005 10:44

Try to use single '/' instead of double '\

rollo mickael · Post by **rollo mickael** » Wed 28 Sep 2005 12:08

with /
The result in the first field nom is now (instead of "marchand"):

delphi7/sources/neoscope2/FILES/IMPORTFILES/temp.t

Ikar · Post by **Ikar** » Wed 28 Sep 2005 14:21

We couldn't reproduce the problem.
Please send us (mydac*crlab*com) a complete small sample to demonstrate it and include script to create table.

Ikar · Post by **Ikar** » Fri 30 Sep 2005 09:05

Thank you for your sample. It did help us very much.
We reproduced your problem and fixed it. This fix will be included in the next MyDAC build. It will be available on next week. Please look forward for announcments at the forum

rollo mickael · Post by **rollo mickael** » Mon 03 Oct 2005 13:15

Thanks for your fix.
But i don't see this problem in the revision history 4.00.1.3 02.09.05.

Is it correct in these version ?

Ikar · Post by **Ikar** » Tue 04 Oct 2005 09:24

No, the fix will be included to MyDAC 4.00.1.5