The VARCHAR data type can store variable-length strings with a maximum length of 8,000 characters.
SQL Server:
VARCHAR data type can store variable-length strings with a maximum length of 8,000 characters.NVARCHAR(MAX) data type can store variable-length Unicode strings with a maximum length of 2^30 - 1 characters.