创建mysql数据库,指定默认编码

create database testdb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;