Data Type Suggestion in Sql Server 2005. Use varchar(max) and varbinary(max)

One of the interesting things that I am reading in the documentation for Sql Server 2005, is that the data types of text and image are going to be removed from a future version of Sql Server.  The varchar(max) and varbinary(max) data types should be used instead.  As I had some previous problems with the text data type with a CLR trigger, moving the column to a varchar(max) was fairly painless.

Wally

2 Comments

  • How much is the max? I do store data that is larger than the 8000 byte row limit in SQL 2000 and if MSSQL 2005 won't support larger rows or text/image data it will definitelly stop me from upgrading. And since by then I will be running a 5 year old database with its support cycle nearing end I will have to switch to a competitor.

  • Varchar(max) has a storage capacity of 2^31 - 1.



    Wally

Comments have been disabled for this content.