MySQL | BINARY and VARBINARY
VARBINARY types in MySQL are similar to
VARCHAR but they store binary strings rather than non-binary strings (i.e. byte strings rather than character strings).
Byte strings have the binary character set and collation. Comparison and sorting is performed based on the numeric value of the bytes.
M represents column length in bytes. It is optional and defaults to
Values will be right-padded with the zero byte (
0x00) to the specified length. The right-padding is included in retrieval.
M represents column length in bytes.
BINARY, no padding is performed when
VARBINARY values are stored.