直接学习:https://edu.csdn.net/course/play/27328/370719
字符集之gb2312装不下“屌丝”:
#1、如何查看mysql支持的字符集
show character set;
#2、设置字符集
#3、示例代码如下:
create table t_gb2312(name varchar(30)) default charset=gb2312;
insert into t_gb2312 values('张三');
insert into t_gb2312 values('屌丝');
insert into t_gb2312 values('陶喆');
create table t_gbk(name varchar(30)) default charset=gbk;
insert into t_gbk values('张三');
insert into t_gbk values('屌丝');
insert into t_gbk values('陶喆');