test_utf8.* TO test_utf8@localhost IDENTIFIED BY 'XXXXXXXXXX'; CREATE DATABASE test_utf8 CHARACTER SET utf8; USE test_utf8; CREATE TABLE test_utf8.moji(id int, moji text); INSERT INTO test_utf8.moji(id, moji) values( '1', 'あいうえお' ); INSERT INTO test_utf8.moji(id, moji) values( '2', '寿司�susi' ); FLUSH PRIVILEGES; $ mysqldump -uroot -p -t test_utf8 moji | grep 'INSERT INTO' INSERT INTO `moji` VALUES (1,'あいうえお'),(2,'寿司'); 4バイト文字以降が消えた → WordPress での動きと一緒