This topic introduces the data types that allow storage of binary strings.

Table 1. Binary Large Object
Name Storage size Description
BINARY The length of the binary string. Fixed-length binary string, with a length between 1 and 8300.
BLOB The actual binary string plus 1 byte if the binary string is less than 127 bytes, or 4 bytes if the binary string is 127 bytes or greater. Variable-length binary string
VARBINARY The length of the binary string Variable-length binary string, with a length between 1 and 8300.

A binary string is a sequence of octets or bytes. Binary strings are distinguished from characters strings by two characteristics: First, binary strings allow storing octets of value zero and other non-printable octets that exceed the range 32 to 126. Second, operations on binary strings process the actual bytes, whereas the encoding and processing of character strings depends on local settings.