DROP TABLE IF EXISTS t1;

DELIMITER $$

BEGIN NOT ATOMIC

  DECLARE var TEXT CHARACTER SET utf8;

  CREATE TABLE t1 AS SELECT var;

END;

$$

DELIMITER ;

SHOW CREATE TABLE t1;

+-------+---------------------------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                                  |

+-------+---------------------------------------------------------------------------------------------------------------+

| t1    | CREATE TABLE `t1` (

  `var` mediumtext CHARACTER SET utf8 DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

+-------+---------------------------------------------------------------------------------------------------------------+