GBK:
create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
UTF8:
CREATE DATABASE test2 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
GBK:
create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
UTF8:
CREATE DATABASE test2 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
原文：https://www.cnblogs.com/stulzq/p/8504471.html