开发者

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

开发者 https://www.devze.com 2023-01-13 19:15 出处:网络
I\'m going to开发者_高级运维 save tutorials and snippets. How big should I declare the column?Declare asvarchar(max) (if the size will exceed 8,000 bytes). (or nvarchar(max) if supporting multi-byte c

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消