创建数据库时设置默认字符集为utf8

create database dbname default charset utf8 collate utf8_general_ci;