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
>I am using SQL Server Express Edition with ASP.NET. I want to know
> which data type to use for storing large articles.
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)
> I am using SQL Server Express Edition with ASP.NET. I want to know
> which data type to use for storing large articles.
Rohit - 18 Sep 2007 16:45 GMT
Does nvarchar(max) allots space according to the text entered or it
reserves the max space by default? I want the former.
> depends on the datatype of the articles. if text or html, use
> nvarchar(max), if xml use xml or if binary use varbinary(max).