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.
精彩评论