Reputation: 518

Keep text formatting in SQL

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?

Upvotes: 3

Answers (3)

Reputation: 1783

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

Either:

Output the text inside a <pre> tag

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

Upvotes: 4

Reputation: 11734

If you mean keep the Enters then replace the char 10 and char 13 with <br/>

When using SQL (note the enters)

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

This results in <br/>test<br/>test

Upvotes: 2

Reputation: 116508

Text is text is text. Insert the text into the table including its markup and it will come out that way as well.

...or am I misunderstanding your question?

Upvotes: 1