How do your keep text formatting when you insert it into database

[Blaine76]

Hi All,
This may seem like a stupid question but is there a way to keep text
formatting when you add it to a database? Such as Paragraphs and line
breaks?

Any help greatly appreciated.

Blaine

[getinked]

Re: How do your keep text formatting when you insert it into database

what kinda field are you using. varchar, nvarchar, text ?

[David Portas]

Re: How do your keep text formatting when you insert it into database

You could save the column with HTML tags or RTF formatting. Or you could
save a formatted document in any format to an IMAGE column. Storing the
formatting isn't a problem. The real question is what method to use to
manipulate and render the formatting in your presentation tier. You should
probably refer to a forum or resource for the application or development
environment you are using.

--
David Portas
SQL Server MVP
--