CREATE TABLE `test` ( `id` int(11) NOT NULL, `test` varchar(10) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; insert into test values (1, '🔍');