Is it possible to change the size limit on ntext fields in SQL Server 2005 or must one convert the field to varchar(max)?
Sql-server – Is is possible to change the ntext size limit in SQL Server 2005
sql serversql-server-2005
Related Topic
- Is it ok to limit the size of templog in SQL Server 2005
- Sql-server – Can a SQL Server 2000 database be hosted on SQL Server 2005/2008
- SQL Server 2005 can’t increase log file size
- Sql-server – Install SQL Server 2005 after installing 2008
- Sql-server – SQL Server 2005 Express: Where is the Profiler
- Sql-server – sql server limitation of data size
Best Answer
The size limit on the CLOB/BLOB fields are fixed (n/text, and image) to 2,147,483,647 bytes. Those datatypes are deprecated as of SQL 2008 and probably won't be included in the next version.
Their updated versions are the varchar(max), nvarchar(max), and varbinary(max) datatypes and they have the same limits. Note that the 'n' prefix in nvarchar and ntext means that Unicode characters are stored in the field, so the real translation from ntext should be to nvarchar(max).
Hope that helps!
Joe