Save text formatting in SQL

Question

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

Answer 1

If you want Enters to replace char 10 and char 13 with <br />

When using SQL (pay attention to input)

select replace(' 
test
test','
','<br/>')

The result is <br/>test<br/>test

Answer 2

I assume that you are talking about keeping line breaks.

Or:

Print text inside the <pre> tag

or

Converting line feed strings to tags before inserting into the database. (For example, nl2br in PHP).

Answer 3

- . , , .

... ?