在oracle中模糊查询默认区分大小写,在mysql中默认不区分
一、查询语句上加binary
select * from user where user.name like binary '%T956' order by id
二、建表时加binary
create table t{
code varchar(10) binary
}
select * from user where user.name like binary '%T956' order by id
create table t{
code varchar(10) binary
}