1
edit
Changes
→MySQL Specifications
* Binary - Hex
:[http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_unhex]
: The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except
that they contain binary strings rather than non-binary strings. That is,
they contain byte strings rather than character strings. This means that
they have no character set, and sorting and comparison are based on the
numeric values of the bytes in the values.
(From MySQL Manual)
* SQL mode
: If strict SQL mode is not enabled and you assign a value to a BINARY or VARBINARY column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated.