This topic introduces the data types that allow storage of binary strings.
|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.