varchar
Jump to navigation
Jump to search
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 bytes(unless varchar(max) is used, which has a maximum storage capacity of 2 gigabytes).[3]
References[edit]
- ^ "Database Concepts". docs.oracle.com.
- ^ "MySQL :: MySQL 5.7 Reference Manual :: 11.4.1 The CHAR and VARCHAR Types". dev.mysql.com.
- ^ edmacauley. "char and varchar (Transact-SQL)". msdn.microsoft.com.
 | This database-related article is a stub. You can help Wikipedia by expanding it. |
