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 ^ https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#i1835 Jump up ^ https://dev.mysql.com/doc/refman/5.7/en/char.html Jump up ^ https://msdn.microsoft.com/en-us/library/ms176089.aspx 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=768525878 '' Categories : SQL Database stubs Talk About Wikipedia Español Français Português ไทย Edit links This page was last edited on 4 March 2017, at 09 : 26. 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: what is the length of varchar(max) in sql server
Answer: 2 gigabytes