SQL Server Data Types (ntext, text, and image) To Be Removed

microsoft, sql server

I was doing some research on data types in various DB engines when you came across the SQL Server 2005 documentation on data types and found that the ntext, text, and image data types will be removed in a future version of SQL Server.

When you plan on upgrading to a new version of anything, make sure to check the documentation for any deprecated functionality that you're using.

This doesn't impact me at the moment, as we haven't even upgraded to 2005 yet.

 
So what is the recommendation for large text if not type "text"?
 
posted 636 days ago
View Replies (1) || Add Comment Reply to: this comment OR this thread
 
.: HIDE REPLIES :.
fro said:
 
As of SQL Server 2005, it is recommended that you use VARCHAR(MAX) which expands the storage capacity from 8,000 characters to 2,147,483,648 characters.

http://msdn2.microsoft.com/en-us/library/ms178158....
 
posted 636 days ago
Add Comment Reply to: this comment OR this thread
 

Search