create table a9

SELECT COLUMN_JSON(COLUMN_CREATE('name', UNHEX('C1C2C3C4C5C6'))) as b

show create table a9:

CREATE TABLE `a9` (

  `b` longblob   <- binary

) ENGINE=MyISAM DEFAULT CHARSET=utf8 <- charset ok