Hi,

I'm storing a text file in a TEXT column using the LOAD_FILE function like 
this:
INSERT ... text_col=LOAD_FILE('filename')

Each line of the orig file ends with char 10.

When I SELECT it like
SELECT text_col INTO OUTFILE 'out_filename' ...


I find that each line has an extra "\" (char 92) inserted as the second 
last char, the last char being char 10.

I've searched through the manual and can't find mention of this, am I 
missing something??

Richard


=======================================
Richard Vibert
[EMAIL PROTECTED]
Tatura Mitre10
=======================================


---------------------------------------------------------------------
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

Reply via email to