A VARCHAR or variable character field is a data type which can contain any type of data such as numeric, characters, spaces and punctuation and the size of the database is depending on the database. VARCHAR are mostly used to act as temporary variables and for string operations. They bring in much-needed versatility for data field types. A VARCHAR can be defined either in the programming language or on the database level and it always has a declared maximum length and is usually initialized with the current length equal to zero. Most relational database management systems support the variable character field.