varchar
Hello, you have come here looking for the meaning of the word varchar. In DICTIOUS you will not only get to know all the dictionary meanings for the word varchar, but we will also tell you about its etymology, its characteristics and you will know how to say varchar in singular and plural. Everything you need to know about the word varchar you have here. The definition of the word varchar will help you to be more precise and correct when speaking or writing your texts. Knowing the definition ofvarchar, as well as those of other words, enriches your vocabulary and provides you with more and better linguistic resources.
English
Etymology
From the data type name, a shortening of variable character.
Pronunciation
Noun
varchar (plural varchars)
- (computing, databases) A text field of indeterminate length in a database, as opposed to the traditional fixed-length field.
- 1999, David K. Rensin, Andrew M. Fedorchek, William C. Amo, Microsoft SQL Server 7 secrets:
- Be aware that varchars will in general provide slower updates but faster selects. By definition, the amount of storage they use is variable.
- 2008, Eric Johnson, Joshua Jones, A Developer's Guide to Data Modeling for SQL Server:
- With a varchar, the storage is always the actual number of characters you have stored plus 2 bytes. So a varchar(20) with a 5-character word will take up 7 bytes, with the extra 2 bytes holding a size reference for SQL Server.