Tuesday, April 10, 2007

SQL Server BLOB datatypes going away

This is something to be aware of:
It looks like the SQL Server datatypes TEXT, NTEXT, IMAGE are going away sometime in the future as noted in SQL server Books online: "ntext, text, and image (Transact-SQL)".

So for any new tables that need to store large data fields, M$ is suggesting to use VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX).

No comments: