Entry

Is there any limit on the char length? What text length should one always specify?

Nov 11th, 2006 11:23
Matt Chatterley, wang wei, Trupti Paralkar,

at sql server 2000:
    The maxium length of char is 8000
    The maxium lenght of text is 2^31 - 1
Note that for SQL 2000, NVARCHAR/NCHAR data has a max limit of 4000 (as
it is unicode, therefore each character consumes double the space).
SQL 2005 is largely the same, but [N][VAR]CHAR(MAX) (lit) is recommended
as an alternative to [N]TEXT as it allows manipulation of a large string
value without the use of text pointers.