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 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 and Microsoft SQL Server 2008 has a limit of 8000 bytes.
nvarchar is a variation of varchar, and which is more suitable depends on the use case.