If CHARACTER SET X is specified without COLLATE, character set X and its default collation are used.
CREATE TABLE t1
(
col1 CHAR(10) CHARACTER SET utf8
) CHARACTER SET latin1 COLLATE latin1_bin;
The character set is specified for the column, but the collation is not. The column has character set utf8 and the default collation for utf8, which is utf8_general_ci. To see the default collation for each character set, use the SHOW COLLATION statement.
http://dev.mysql.com/doc/refman/5.5/en/charset-col umn.html