1.创建数据库

create database tms CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

2.创建表

create table tbtest(

id int(10) auto_increment,

user_name varchar(60) CHARACTER SET GBK COLLATE gbk_chinese_ci,

email varchar(60),

PRIMARY key(id)

)CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

3.修改库

alter table tms character set utf8mb4 COLLATE utf8mb4_general_ci;

4.修改表

ALTER TABLE tbtest MODIFY email VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

5.查看所有编码

-- 查看所有的字符编码
SHOW CHARACTER SET;
-- 查看创建数据库的指令并查看数据库使用的编码
show create database dbtest;
-- 查看数据库编码：
show variables like '%char%';