faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

45 of 55 people (82%) answered Yes
Recently 8 of 10 people (80%) answered Yes

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.