varchar
Sign in to saveAlso known as variable character field, char varying, character varying
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 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 bytes (unless varchar(max) is used, which has a maximum storage capacity of 2 gigabytes).
In the Vinony graph
Within Vinony's link graph, varchar is referenced by 2 other articles, and connects out to database, data and SQL.
It is catalogued under topics including Data types and SQL.
Its subject is documented across 6 Wikipedia language editions.
~1 min read
Encyclopedic overview
2 sectionsContents
- See also
- References
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 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 bytes (unless varchar(max) is used, which has a maximum storage capacity of 2 gigabytes).
nvarchar is a variation of varchar, and which is more suitable depends on the use case.
Excerpted from Wikipedia’s “varchar” article, available under the CC BY-SA 4.0 licence.