Varchar - Wikipedia Varchar A varchar or Variable Character Field is a set of character data of indeterminate length. The term varchar refers to a data type of a field ( or column ) in a database management system which can hold letters and numbers. 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, a MySQL 5.7 database has a limit of 65,535 bytes ( for the entire row ) 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 ). References Jump up ^ `` Database Concepts ''. docs.oracle.com. Jump up ^ `` MySQL : : MySQL 5.7 Reference Manual : : 11.4. 1 The CHAR and VARCHAR Types ''. dev.mysql.com. Jump up ^ edmacauley. `` char and varchar ( Transact - SQL ) ''. msdn.microsoft.com. This database - related article is a stub. You can help Wikipedia by expanding it. Retrieved from `` https://en.wikipedia.org/w/index.php?title=Varchar&oldid=810606021 '' Categories : SQL Database stubs Talk About Wikipedia Español Français Português ไทย Edit links This page was last edited on 16 November 2017, at 09 : 00. Text is available under the Creative Commons Attribution - ShareAlike License ; additional terms may apply. By using this site, you agree to the Terms of Use and Privacy Policy. Wikipedia ® is a registered trademark of the Wikimedia Foundation, Inc., a non-profit organization. About Wikipedia

Question: maximum size of varchar max in sql server
Answer: 8000 characters (unless varchar(max) is used, which has a maximum storage capacity of 2 gigabytes)