Mysql中utf8_general_ci和utf8_bin区别

sno bigint(20) not null comment '学生编号',
sname varchar(15) CLOOATE utf8mb4_bin not null comment '学生姓名',
PRIMARY KEY (sno)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 CLLATE=utf8mb4_bin COMMENT='用户名表';

utf8_general_ci --不区分大小写
utf8_bin–区分大小写