Does mySQL preserve line breaks?

[SubKamran]

Cuz I'm converting from Access to mySQL, and in Access, it doesn't preserve them...does mySQL?

just a simple question...I have the code...

[seanf]

As in \n \r and \r\n? Yep it does

Moved to a more appropriate forum

Sean

[SubKamran]

er. I mean directly from a textarea when added into a field...that would be 'CHR(10)' in ASP...

[JEmLAC]

Originally posted by SubKamran
Cuz I'm converting from Access to mySQL, and in Access, it doesn't preserve them

I know this isn't exactly what your original question was asking, but an Access database does preserve line breaks. When I create a table and hang a form off it, from within Access, I have to set the field to accept enter key as a new line and when I edit the field directly on the table I have to do ctrl-Enter to put a line break.

I did a simple HTML form submitting to an ASP that connected to an Access database and passed a textarea value that had multiple line breaks. The string passed to the ASP and the insert query on the ASP put the string, line breaks and all, into the Access table. I looked at the Access table and the line breaks are there. Are you sure your Access database isn't capturing the line breaks? You may have to adjust the field height of your table to see the extra lines.

B