Opened 11 years ago
Closed 5 years ago
#5132 closed defect (wontfix)
OGR SQL ILIKE is case sensitive with non-latin letters
Reported by: | marisn | Owned by: | warmerdam |
---|---|---|---|
Priority: | normal | Milestone: | closed_because_of_github_migration |
Component: | default | Version: | 1.9.2 |
Severity: | normal | Keywords: | |
Cc: |
Description
Although documentation states LIKE and ILIKE being case-insensitive, both are case sensitive if pattern contains non-latin letter.
Shortened output demonstrating case:
GDAL 1.9.2, released 2012/10/08 ogrinfo -sql "select count(NOSAUKUMS) from pilsetas where NOSAUKUMS ilike '%ā%'" pilsetas.shp COUNT_NOSAUKUMS (Integer) = 8 ogrinfo -sql "select count(NOSAUKUMS) from pilsetas where NOSAUKUMS like '%ā%'" pilsetas.shp COUNT_NOSAUKUMS (Integer) = 8 ogrinfo -sql "select count(NOSAUKUMS) from pilsetas where NOSAUKUMS ilike '%Ā%'" pilsetas.shp COUNT_NOSAUKUMS (Integer) = 2 ogrinfo -sql "select count(NOSAUKUMS) from pilsetas where NOSAUKUMS like '%Ā%'" pilsetas.shp COUNT_NOSAUKUMS (Integer) = 2
As it's visible from the output, count should be 10 if ILIKE is case-insensitive. Example works as expected (LIKE and ILIKE both are case-insensitive) when using plain "a" letter.
Change History (1)
comment:1 by , 5 years ago
Milestone: | → closed_because_of_github_migration |
---|---|
Resolution: | → wontfix |
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
This ticket has been automatically closed because Trac is no longer used for GDAL bug tracking, since the project has migrated to GitHub. If you believe this ticket is still valid, you may file it to https://github.com/OSGeo/gdal/issues if it is not already reported there.