MySQL 8.4 Release Notes
The BINARY and VARBINARY
types are similar to CHAR and
VARCHAR, except that they store
binary strings rather than nonbinary strings. That is, they
store byte strings rather than character strings. This means
they have the binary character set and
collation, and comparison and sorting are based on the numeric
values of the bytes in the values.