Question

What Is The Maximum Length Of A Varchar In Sql Server?

Answer 1

Varchar fields can be of any size up to a limit, which varies by databases: an Oracle 11g database has a limit of 4000 bytes,[1] a MySQL 5.7 database has a limit of 65,535 bytes (for the entire row)[2] and Microsoft SQL Server 2008 has a limit of 8000 characters (unless varchar(max) is used, which has a maximum storage capacity of 2 gigabytes).

Hope it helped you      :)