Jump to content

varchar

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Magioladitis (talk | contribs) at 09:26, 4 March 2017 (punctuation placement and other fixes using AWB). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.


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,[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).[3]

References

  1. ^ https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#i1835
  2. ^ https://dev.mysql.com/doc/refman/5.7/en/char.html
  3. ^ https://msdn.microsoft.com/en-us/library/ms176089.aspx


Stub icon

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"