SQL Server DataType for articles

  • Thread starter Thread starter Rohit
  • Start date Start date
R

Rohit

I am using SQL Server Express Edition with ASP.NET. I want to know
which data type to use for storing large articles.
 
Well, that depends on what you mean by an 'Article' Articles are composed of
many things. And can be stored in a variety of ways.

If your question is as simple as how do I store a resonably large amount of
text, then the 'Text' DataType may do it. Perhaps you could be more
specific about precicely what it is you indent to store. This would be more
helpful in answering your question.

HTH
 
depends on the datatype of the articles. if text or html, use
nvarchar(max), if xml use xml or if binary use varbinary(max).


note: image and text are obsolete

-- bruce (sqlwork.com)
 
Does nvarchar(max) allots space according to the text entered or it
reserves the max space by default? I want the former.
 
Back
Top