How big should I declare my SQL Server column if it's going to hold an Article body?

I'm going to开发者_高级运维 save tutorials and snippets. How big should I declare the column?

Declare as varchar(max) (if the size will exceed 8,000 bytes). (or nvarchar(max) if supporting multi-byte character sets)

varchar(max) or nvarchar(max)

[TEXT(MAX) or NTEXT(MAX) are being deprecated in future versions.]

If you mean what datatype, probably you need nvarchar(max). If you are still on SQL Server 200 you need ntext or text.