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, exceptthat they contain binary strings rather than non-binary strings. That is,they contain byte strings rather than character strings. This means thatthey have no character set, and sorting and comparison are based on thenumeric 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.
