Saving HTML formatted text in a database

Question

I am building a website similar to Craigslist. I would like to know how to save text in html format (bold / italic / font size etc.) in sql 2008 database?

In word order, the user enters their text, formats it with font size, bold, etc. and saves information. What is the most efficient way to store this in a database?

Answer 1

Save it in the nvarchar (max) field. Make sure you use parameterized queries for security. Read http://www.aspnet101.com/2007/03/parameterized-queries-in-asp-net/

Answer 2

, HTML, - script.

, <script> <style>. script, ! .

Answer 3

, , nvarchar (max)

Answer 4

, NVARCHAR () XML.

, xml - .

Answer 5

, , NVARCHAR (MAX).

, .

Answer 6

I would put it in the nvarchar (MAX) field if you are using SQL Server 2008 or higher otherwise. If you are using SQL Server 2005 or lower, and if the character count is below 2000, you can use the nvarchar (2000) type. If this limits the use of the text type too much.