方法1--加关键字binary
;
select
*from `sys_user`
where binary loginno = 'qqq'
方法2--更改字段排序规格为utf8_bin;
ALTER TABLE `p_info`
MODIFY COLUMN `manager` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '停车场管理员账号' AFTER `short_name`
方法1--加关键字binary
;
select
*where binary loginno = 'qqq'
方法2--更改字段排序规格为utf8_bin;
ALTER TABLE `p_info`
MODIFY COLUMN `manager` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '停车场管理员账号' AFTER `short_name`