Data types in the binary category include:
- bit variables store a single bit with a value of 0, 1 or NULL.
- binary(n) variables store n bytes of fixed-size binary data. They may store a maximum of 8,000 bytes.
- varbinary(n) variables store variable-length binary data of approximately n bytes. They may store a maximum of 8,000 bytes.
- varbinary(max) variables store variable-length binary data of approximately n bytes. They may store a maximum of 2 gigabytes.
- image variables store up to 2 gigabytes of data and are commonly used to store any type of data file (not just images).
