mysql在命令行模式下创建数据库时要显式指定字符集

create database db1 DEFAULT CHARACTER SET utf8 COLLATE utf8_chinese_ci;