issues with search for non-latin alphabets (case-sensitivity and accents)

[FotisK]

Hi, I've noticed a couple of issues when searching in non-latin (specifically greek) text: I have a field with values such as "Βορράς", "βορράς", "βορρας", "Βορρας", "ΒΟΡΡΑΣ" and "ΒΌΡΡΑΣ" All these values ideally should be considered identical (case insensitive and accent stripping) but currently they are treated as different strings.

[joshirio]

This is a limitation of the SQLite backend which handles unicode characters that are outside the ASCII range as case sensitive:

from https://www.sqlitetutorial.net/sqlite-like/

However, for Unicode characters that are not in the ASCII ranges, the LIKE operator is case sensitive e.g., "Ä" LIKE "ä" is false.

I'll think about a workaround.

[FotisK]

ah ic, that makes sense @joshirio ! Thank you for all the time you've put into my issue and the whole project.