"varchar" meaning in All languages combined

See varchar on Wiktionary

Noun [English]

IPA: /ˈvɑːt͡ʃɑː/ [UK], /ˈvɑɹt͡ʃɑɹ/ [US], /ˈvɛ(ə)ɹkɛ(ə)ɹ/ [US] Forms: varchars [plural]
Etymology: From the data type name, a shortening of variable character. Head templates: {{en-noun}} varchar (plural varchars)
  1. (computing, databases) A text field of indeterminate length in a database, as opposed to the traditional fixed-length field. Wikipedia link: varchar Categories (topical): Computing, Databases

Inflected forms

Download JSON data for varchar meaning in All languages combined (2.1kB)

{
  "etymology_text": "From the data type name, a shortening of variable character.",
  "forms": [
    {
      "form": "varchars",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "varchar (plural varchars)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        {
          "kind": "other",
          "name": "English entries with incorrect language header",
          "parents": [
            "Entries with incorrect language header",
            "Entry maintenance"
          ],
          "source": "w"
        },
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Computing",
          "orig": "en:Computing",
          "parents": [
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        },
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [
            "Computing",
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        }
      ],
      "examples": [
        {
          "ref": "1999, David K. Rensin, Andrew M. Fedorchek, William C. Amo, Microsoft SQL Server 7 secrets",
          "text": "Be aware that varchars will in general provide slower updates but faster selects. By definition, the amount of storage they use is variable.",
          "type": "quotation"
        },
        {
          "ref": "2008, Eric Johnson, Joshua Jones, A Developer's Guide to Data Modeling for SQL Server",
          "text": "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.",
          "type": "quotation"
        }
      ],
      "glosses": [
        "A text field of indeterminate length in a database, as opposed to the traditional fixed-length field."
      ],
      "id": "en-varchar-en-noun-vwlZCxWo",
      "links": [
        [
          "computing",
          "computing#Noun"
        ],
        [
          "database",
          "database"
        ],
        [
          "field",
          "field"
        ]
      ],
      "raw_glosses": [
        "(computing, databases) A text field of indeterminate length in a database, as opposed to the traditional fixed-length field."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "varchar"
      ]
    }
  ],
  "sounds": [
    {
      "ipa": "/ˈvɑːt͡ʃɑː/",
      "tags": [
        "UK"
      ]
    },
    {
      "ipa": "/ˈvɑɹt͡ʃɑɹ/",
      "tags": [
        "US"
      ]
    },
    {
      "ipa": "/ˈvɛ(ə)ɹkɛ(ə)ɹ/",
      "tags": [
        "US"
      ]
    }
  ],
  "word": "varchar"
}
{
  "etymology_text": "From the data type name, a shortening of variable character.",
  "forms": [
    {
      "form": "varchars",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "varchar (plural varchars)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        "English 2-syllable words",
        "English 3-syllable words",
        "English countable nouns",
        "English entries with incorrect language header",
        "English lemmas",
        "English nouns",
        "English terms with IPA pronunciation",
        "English terms with quotations",
        "Quotation templates to be cleaned",
        "en:Computing",
        "en:Databases"
      ],
      "examples": [
        {
          "ref": "1999, David K. Rensin, Andrew M. Fedorchek, William C. Amo, Microsoft SQL Server 7 secrets",
          "text": "Be aware that varchars will in general provide slower updates but faster selects. By definition, the amount of storage they use is variable.",
          "type": "quotation"
        },
        {
          "ref": "2008, Eric Johnson, Joshua Jones, A Developer's Guide to Data Modeling for SQL Server",
          "text": "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.",
          "type": "quotation"
        }
      ],
      "glosses": [
        "A text field of indeterminate length in a database, as opposed to the traditional fixed-length field."
      ],
      "links": [
        [
          "computing",
          "computing#Noun"
        ],
        [
          "database",
          "database"
        ],
        [
          "field",
          "field"
        ]
      ],
      "raw_glosses": [
        "(computing, databases) A text field of indeterminate length in a database, as opposed to the traditional fixed-length field."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "varchar"
      ]
    }
  ],
  "sounds": [
    {
      "ipa": "/ˈvɑːt͡ʃɑː/",
      "tags": [
        "UK"
      ]
    },
    {
      "ipa": "/ˈvɑɹt͡ʃɑɹ/",
      "tags": [
        "US"
      ]
    },
    {
      "ipa": "/ˈvɛ(ə)ɹkɛ(ə)ɹ/",
      "tags": [
        "US"
      ]
    }
  ],
  "word": "varchar"
}

This page is a part of the kaikki.org machine-readable All languages combined dictionary. This dictionary is based on structured data extracted on 2024-06-01 from the enwiktionary dump dated 2024-05-02 using wiktextract (384852d and db5a844). The data shown on this site has been post-processed and various details (e.g., extra categories) removed, some information disambiguated, and additional data merged from other sources. See the raw data download page for the unprocessed wiktextract data.

If you use this data in academic research, please cite Tatu Ylonen: Wiktextract: Wiktionary as Machine-Readable Structured Data, Proceedings of the 13th Conference on Language Resources and Evaluation (LREC), pp. 1317-1325, Marseille, 20-25 June 2022. Linking to the relevant page(s) under https://kaikki.org would also be greatly appreciated.