SET NAMES "utf8"; CREATE DATABASE test_x DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE test_x; CREATE TABLE test ( body longtext NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO test (body) VALUES ('test before􀂃test after');