MySQL创建数据库时指定数据库编码

UTF8:

mysql> CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

GBK:

mysql> create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;