Maximum size of VARCHAR(MAX) in SQL Server 2005

Question

We should use varcharmax when length of string varies and max limit is 2GB Is it supported in older versions like SQL server 2005If supports then still the MAX size limit is 2GB

dharmendr · Accepted Answer

Hi soumyaraniYes varcharmax is supported in SQL Server 2005 It applies to all supported versions of SQL ServerIts MAX size limit is 2GBFor more details refer below linkchar and varchar

Maximum size of VARCHAR(MAX) in SQL Server 2005

Company

Explore

Follow us

Contact Us