Do you want to buy me a beer or coffee?

Wednesday, January 28, 2009

Varchar(max) and NVarchar(max)

Varchar(max) size limit in SQL 2005 is 2^31-1 bytes or 2,147,483,648 bytes. I haven't test the limit yet. According to MSN "Use varchar(max) when the sizes of the column data entries vary considerably, and the size might exceed 8,000 bytes".

NVarchar(max) in SQL 2005 is 4000 characters.



SQL 2005

0 comments:

Post a Comment

<--nothing-->