Jul 172010
What are the difference between CHAR BINARY and BINARY type in MySQL
Answer:
For CHAR BINARY, the BINARY keyword does not cause the column to store binary value, instead, it cause the column to use binary collation only. The actual character set used depend on the system.
For BINARY column, the actual data is treated as binary, so no charset and collation rules apply.
Reference: http://dev.mysql.com/doc/refman/5.1/en/binary-varbinary.html