--CHARACTERSET:指定数据库采用的字符集,utf8不能写成utf-8--COLLATE:指定数据库字符集的排序规则,utf8的默认排序规则为utf8_general_ci(通过show character set查看)
drop database ifEXISTS db_test01;
create database test01 DEFAULTCHARACTERSET utf8 COLLATE utf8_general_ci;
修改数据库编码
alter database db_test01 CHARACTERSETGBKCOLLATE gbk_chinese_ci;
alter database db_test01 CHARACTERSET utf8 COLLATE utf8_general_ci;
创建表时,设置表、字段编码
use db_test01;
drop table if exists tb_test01;
create table tb_test01(
id int(18) auto_increment,
name varchar(60)CHARACTERSETGBKCOLLATE gbk_chinese_ci,
email varchar(60),PRIMARYkey(id))CHARACTERSET utf8 COLLATE utf8_general_ci;
修改表编码
alter table tb_test01 character set utf8 COLLATE utf8_general_ci;