Keep text formatting in SQL

Question

I have a text area that inserts its content into a SQL table. Is there a way to keep the formatting of the text and then use it in HTML?

Answer 1

I'll assume you're talking about preserving line breaks.

Either:

Output the text inside a <pre> tag

or

Convert newlines to <br /> tags before insertion to the DB. (E.g. nl2br in PHP).