VARCHAR is a Variable Length string data type.

Declaration


VARCHAR ( varcharLength )

Arguments

  • varcharLength: Defines the maximum length for a value in this column.

String Type

  • Variable Length

Storage Size

  • Based on varcharLength, where varcharLength is the number of bytes.

Additional Information

  • Values that are shorter than varcharLength are not padded with spaces to be varcharLength.

  • varcharLength must be an integer between 1 and 32,672, inclusive, which is the number of bytes.

Examples


VARCHAR(1)
a

VARCHAR(12)
Text value