This topic describes the data types that can be stored by binary strings.

Table 1. Binary large objects
Name Length Description
BINARY The same as the length of the binary string. The fixed-length binary string. The string must be from 1 to 8,300 bytes in length.
BLOB The actual binary string plus 1 byte if the binary string is less than 127 bytes in length. If the binary string is greater than or equal to 127 bytes in length, the length equals the actual binary string plus 4 bytes. The variable-length binary string.
VARBINARY The same as the length of the binary string. The variable-length binary string. The string must be from 1 to 8,300 bytes in length.
A binary string is a sequence of octets or bytes. Binary strings are distinguished from character strings in the following two aspects:
  • Binary strings can store octets of zero values and other non-displayable octets whose length is out of the range from 32 to 126 bytes.
  • Operations on binary strings process the actual bytes, whereas the encoding and processing of character strings depend on local settings.