Load data infile (data erroneous) with version 3.55.0.21

Load data infile (data erroneous) with version 3.55.0.21

Postby 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 ?
rollo mickael
 
Posts: 3
Joined: Fri 24 Jun 2005 13:44

Postby Ikar » Wed 28 Sep 2005 10:44

Try to use single '/' instead of double '\
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby 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
rollo mickael
 
Posts: 3
Joined: Fri 24 Jun 2005 13:44

Postby 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
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby 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
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby 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 ?
rollo mickael
 
Posts: 3
Joined: Fri 24 Jun 2005 13:44

Postby Ikar » Tue 04 Oct 2005 09:24

No, the fix will be included to MyDAC 4.00.1.5
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components