Maximum size of VARCHAR(MAX) in SQL Server 2005

Last Reply one month ago By dharmendr

Posted one month ago

We should use varchar(max) when length of string varies and max limit is 2GB. Is it supported in older versions like SQL server 2005?

If supports then still the MAX size limit is 2GB?

You are viewing reply posted by: dharmendr one month ago.
Posted one month ago

Hi soumyarani,

Yes varchar(max) is supported in SQL Server 2005. It applies to all supported versions of SQL Server.

Its MAX size limit is 2GB.

For more details refer below link.

char and varchar