开发者

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

开发者 https://www.devze.com 2022-12-16 19:48 出处:网络
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.

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

精彩评论

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