CODEWITHSUNDEEP
sql-server
timu
timu

Reputation: 838

Should I avoid use of TEXT, NTEXT datatypes?

I'm making a blog, article website so i decide to use NTEXT data type for blog and article contents. Until i see this

Important

ntext, text, and image data types will be removed in a future version of MicrosoftSQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.

Fixed and variable-length data types for storing large non-Unicode and Unicode character and binary data. Unicode data uses the UNICODE UCS-2 character set. (http://msdn.microsoft.com/en-us/library/ms187993.aspx)

Im sure that blog and article contents gonna reach 4000 character limit if i use nvarchar(max). What data type should i use at this case?

Upvotes: 2

Views: 1181

Answers (1)

AlexS
AlexS

Reputation: 2386

You should use nvarchar(max)/varchar(max) - that's current pair of text types.

When using these types you have no limit for field size (well, actually the limit is 2 Gb, but I don't think you'll hit it).

See MSDN for more details:

Upvotes: 10

Related Questions