You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In layer Filter "lower" function not working with driacritrical marks.
GPKG does not support ILIKE so my idea was to use lower function instated of ILIKE.
Everything is OK till text value doesn't contain driacritrical marks.
When I use layer filter: lower("City")='żytniów' i have no results.
When I use: lower("City")='Żytniów' OR lower("City")='ŻytniÓw' everything works fine
The goal is to easy filer large data with different large of letters in cities names.
Of course it is possible to convert cities name do lower letters in field calculator and then filtering will be easy.
Steps to reproduce the issue
Make simply gpkg, utf-8 dataset with text field City and attributes: Żytniów, ŻYTNIÓW, Paris, PARIS
Set layer Filter: lower("City")='żytniów' and see no results
Try layer Filter: lower("City")='paris' and see correct two results
Versions
Wersja QGIS
3.38.3-Grenoble
Rewizja QGIS 37f9e6e
Wersja Qt
5.15.13
Wersja Pythona
3.12.6
Wersja GDAL/OGR
3.9.2
Wersja PROJ
9.4.0
Wersja bazy danych Rejestru EPSG
v11.004 (2024-02-24)
Wersja GEOS
3.12.2-CAPI-1.18.2
Wersja SQLite
3.45.1
Wersja PDAL
2.6.3
Wersja klienta PostgreSQL
16.2
Wersja SpatiaLite
5.1.0
Wersja QWT
6.2.0
Wersja QScintilla2
2.14.1
Wersja systemu operacyjnego
Windows 11 Version 2009
What is the bug or the crash?
In layer Filter "lower" function not working with driacritrical marks.
GPKG does not support ILIKE so my idea was to use lower function instated of ILIKE.
Everything is OK till text value doesn't contain driacritrical marks.
When I use layer filter:
lower("City")='żytniów'
i have no results.When I use:
lower("City")='Żytniów' OR lower("City")='ŻytniÓw'
everything works fineThe goal is to easy filer large data with different large of letters in cities names.
Of course it is possible to convert cities name do lower letters in field calculator and then filtering will be easy.
Steps to reproduce the issue
Make simply gpkg, utf-8 dataset with text field City and attributes: Żytniów, ŻYTNIÓW, Paris, PARIS
Set layer Filter:
lower("City")='żytniów'
and see no resultsTry layer Filter:
lower("City")='paris'
and see correct two resultsVersions
Wersja QGIS
3.38.3-Grenoble
Rewizja QGIS
37f9e6e
Wersja Qt
5.15.13
Wersja Pythona
3.12.6
Wersja GDAL/OGR
3.9.2
Wersja PROJ
9.4.0
Wersja bazy danych Rejestru EPSG
v11.004 (2024-02-24)
Wersja GEOS
3.12.2-CAPI-1.18.2
Wersja SQLite
3.45.1
Wersja PDAL
2.6.3
Wersja klienta PostgreSQL
16.2
Wersja SpatiaLite
5.1.0
Wersja QWT
6.2.0
Wersja QScintilla2
2.14.1
Wersja systemu operacyjnego
Windows 11 Version 2009
Active Python plugins
db_manager
0.1.20
grassprovider
2.12.99
MetaSearch
0.3.6
processing
2.12.99
Supported QGIS version
New profile
Additional context
No response
The text was updated successfully, but these errors were encountered: