Re: backslash before newline

2003-02-09 Thread Dan Nelson
In the last episode (Feb 06), Michael Boudreau said: > Here's something weird: text strings containing newlines seem to have a > backslash character added when the data is exported from the database. > (MySQL 3.23.37 on Solaris--yes we're upgrading to .54) > > However, when I read the data out t

Re: backslash before newline

2003-02-09 Thread Keith C. Ivey
On 6 Feb 2003, at 8:58, Michael Boudreau wrote: > mysql> select review into outfile '/tmp/MS55038rev1.txt' from > MsReviews where > msid=55038 and msreviewid=1; > Query OK, 1 row affected (0.00 sec) > mysql> quit > Bye > > The newline seems to have had a "\" (backslash, octal

backslash before newline

2003-02-07 Thread Michael Boudreau
Here's something weird: text strings containing newlines seem to have a backslash character added when the data is exported from the database. (MySQL 3.23.37 on Solaris--yes we're upgrading to .54) I entered the string "123\n456" (the "\n" is a newline, octal 012) into a column defined as "text