Re: Can LOAD DATA ignorecharacters normally needing escapes inside fields?

DaveO wrote:
> A windows platform application generates a file consisting of comma 
> separated text whose fields are enclosed in double quotes. When 
> executing the load data infile command, the backslash characters in 
> field "path" cause problems. There isn't a way to have the windows 
> application generate escaped backslashes, i.e. \\.
> 
> I suppose I could make a separate pass through the text file doing a 
> text substitution, but I'd prefer to avoid that.
> 
> Is there a way to have LOAD DATA INFILE not pay attention to the 
> contents of a field when loading it?

Have you already tried using ... FIELDS ESCAPED BY '' ... ?

-- 
Todd Farmer, Support Engineer
MySQL Inc., www.mysql.com

MySQL Conference & Expo - http://www.mysqlconf.com/
 April 23-26 in Santa Clara, California (US)

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]