SQL Server DataType for articles

[Rohit]

I am using SQL Server Express Edition with ASP.NET. I want to know
which data type to use for storing large articles.

 

[Just Me]

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

 

[bruce barker]

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)

 

[Rohit]

Does nvarchar(max) allots space according to the text entered or it
reserves the max space by default? I want the former.