- Oracle数据库:
select * from mob where key_word like '%wre%'
select * from mob where key_word like '%WRE%'
默认区分大小写,两者查询结果不同
- MySQL数据库:
- Windows:默认不区分大小写;
- Linux:默认区分大小写,可以设置一个属性 lower_case_table_names = 1
select * from mob where key_word like '%wre%'
select * from mob where key_word like '%WRE%'
默认区分大小写,两者查询结果不同