Bug report #13656
LIKE is not case sensitive when Query Builder is accessed from Layer > shapefile > Filter... (QGIS, v10, Windows7)
|Affected QGIS version:||2.10.0||Regression?:||No|
|Operating System:||Windows 7||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||duplicate|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||21691|
When using the Query Builder accessed via 'LAYER > right/CTRL-click SHAPEFILE layer > FILTER...' with wildcards (i.e, %) the operator LIKE (case-sensitive) performs identically to ILIKE (NOT case sensitive).
For example, consider a field called NAME that contains the following ('California', 'New Mexico', 'Michigan').
When accessed via Filter..., the query: "NAME LIKE '%c%' returns all three of the above, but the same query performed via 'Select by Expression' and 'Advanced Filter' returns (correctly, I think) only 'New Mexico' and 'Michigan'. This behavior has been replicated on different shapefiles.