VARCHAR FOR BIT DATA is a variable length Binary Data Type.

Declaration


VARCHAR ( varcharLength ) FOR BIT DATA

Binary Type

  • Variable Length

Storage Size

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

Additional Information

Use this information when declaring column types with the CREATE TABLE statement or casting values to new data_types for use in functions or output.

  • Use the CAST function to cast one value to match the other type.

  • When inserting binary data into a binary type column, precede the value with an ‘X’ identifier.

Examples


VARCHAR(1) FOR BIT DATA

Xa

VARCHAR(15) FOR BIT DATA

XText value