MariaDB [test]> create table t (a char(1) collate binary);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'binary)' at line 1

MariaDB [test]> create table t (a char(1) collate `binary`);

Query OK, 0 rows affected (0.033 sec)

MySQL [test]> create table t (a enum('a') character set binary, b char(8)) character set latin1;

Query OK, 0 rows affected (0.194 sec)

MySQL [test]> show create table t \G

*************************** 1. row ***************************

       Table: t

Create Table: CREATE TABLE `t` (

  `a` enum('a') CHARACTER SET binary COLLATE binary DEFAULT NULL,

  `b` char(8) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1

1 row in set (0.001 sec)