Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
The BINARY data type stores binary data of a specified maximum length (in bytes).
BINARY [ ( max-length ) ]
The maximum length of the value, in bytes. If the length is not specified, then it is 1.
The length must be in the 1 to 32767 range.
During comparisons, BINARY values are compared exactly byte for byte. This differs from the CHAR data type, where values are
compared using the collation sequence of the database.
If one binary string is a prefix of the other, the shorter string is considered to be less than the longer string.
Unlike CHAR values, BINARY values are not transformed during character set conversion.
BINARY is semantically equivalent to VARBINARY. It is a variable-length type. In other database management systems, BINARY
is a fixed-length type.
The BINARY data type is SQL language feature T021 of the SQL/2008 standard.