开发者

What is the best datatype for storing a blogpost in SQL Server?

I´m using SQL Server and programming a blogtool.

I want to store texts longer than 4000 chars and a want it to be fast searchable.

Is ntext the right datatype to 开发者_如何转开发use?


use varchar(max) or nvarchar(max) - the text and ntext datatypes are deprecated and should no longer be used


Ray is correct - use Varchar(Max) or NVarchar(Max). This supports data up to 2GB.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜