I´m using SQL Server and programming a blogtool.
I want to store texts longer than 4000 chars and a want it to be fast searchable.
Is ntext the right datatype to use?
+8
A:
use varchar(max) or nvarchar(max) - the text and ntext datatypes are deprecated and should no longer be used
Ray
2010-01-16 16:27:15
What is the maximum length for nvarchar(max)?
Glenn
2010-01-16 16:29:20
Normally is 4000 chars, and 8000 for varchar, but it depends on the size of other columns in the same table I think
Jader Dias
2010-01-16 16:31:43
varchar(max) and nvarchar(max) should go up to 2GB - it is only available as of sql 2005
Ray
2010-01-16 16:43:04
A:
Ray is correct - use Varchar(Max) or NVarchar(Max). This supports data up to 2GB.
Bob Palmer
2010-01-16 16:38:28