Load data infile...

[Lisa He]

Hi,

I have a question with regards to Load data infile...
I have a .txt file containging only path names e.g " C:\temp " in the bodytext. this file is imported into the DB using load data infile.

However, when i do a "select * " on that table which i've just imported, the result looks like this:

C:temp\r

so i assume what has happened is that when this file is imported into MYSQL, MYSQL treats any forward-slashes as codes. i.e. \t , \n , \r etc

I have tried to put double quotes around the pathnames but it doesn't help.

What should i do so that the path name does not get truncated??

thanks, i'd appreciate the help

regards,
Lisa



_________________________________________________________________
Fynda på nätet! Handla på MSN Shopping http://www.msn.se/shopping


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php