I was browsing google searching for information on data types as I was creating a new table in my db. Just wanted to make sure I was doing things right and I came across this snippet notifying of the following:

Important

ntext, text, and image data types will be removed in a future version of Microsoft SQL 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 string and binary data. Unicode data uses the UNICODE UCS-2 character set.

So in this particular table I did use varchar(MAX) instead of text. Didn't even know there was varchar(max) or I forgot.

This entry was posted on March 2, 2012 at 2:36 PM and has received 371 views. There are currently 0 comments. Print this entry.