Handling line feeds

[audiopro]

What is the correct way to handle line feeds when storing multi line text paragraphs in MySQL?
The returns just seem to just disappear and leave me with a sinle line of text.
I would ask in the MySQL forum but they just tell me to use PHP.

I could go for HTML substitution but there must be a simple solution.

Keith

http://www.studiosoft.co.uk

 

[travs69]

i think it will store \n 's with no problem. Your not chomping the data before you insert it are you?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[travs69]

I just inserted some into a varchar field and a text field (which I think in mysql is same as a unlimited length varchar field).

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[audiopro]

I am not chomping the data but I am being a bit numb, it's been a long day.
I am inserting the data into a HTML template and expecting form feeds to morph into line breaks.

In case anyone views this thread looking for a solution, the line feeds need substituting for HTML breaks.

$RawLine=~ s/\n/<br>/g;

Keith

http://www.studiosoft.co.uk

 

[travs69]

you can always put pre tags around it to.. but sometimes they look funny.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;