deltachat-core icon indicating copy to clipboard operation
deltachat-core copied to clipboard

Search should be case-insensitive for non-ascii characters

Open staviss opened this issue 7 years ago • 8 comments

The contact search seems to be case-sensitive for russian letters, and it seems to be weird :)

/ Delta 0.99

staviss avatar Dec 30 '17 13:12 staviss

What do you mean with "weird"? Just the case-insensivity? Or some additional bug?

r10s avatar Jan 05 '18 11:01 r10s

I mean case-sensivity! It is strange to shift the first letter of a name, or a surname, for the search. F.E.: I search "бьёрн" and don't get "Бьёрн". "илья" doesn't get "Илья", "алекс" doesn't get "Александр", and so on.

staviss avatar Jan 05 '18 15:01 staviss

I have understood this. I was just wondering if there are more things "weird" :)

Regarding the issue: In fact, it does not work for german umlauts, too :( Eg. typing BJÖRN won't find Björn - however, as there are few names starting with umlauts, it was not yet noticed here.

A quick research on the problems:

  • It seems as if the ICU extension is not available in sqlite, see https://www.sqlite.org/src/dir?name=ext/icu
  • query the database on 16.04 ubuntu with sqliteman has the same problem
  • I think in the deltachat-core, everything is done correctly (creating the index with NOCASE, LIKE defaults to nocase)

So, finally, we just need someone to figure out how ICU can be enabled.

r10s avatar Jan 05 '18 15:01 r10s

NB: maybe you can edit the title if this issue to a more general one - in fact, it affects most non-english-languages in a way ...

r10s avatar Jan 05 '18 16:01 r10s

"Weird" is for strange, unusual, bizarre here :)

Ok. Correcting the issue name.

/Ilya

staviss avatar Jan 05 '18 16:01 staviss

Thanks :)

r10s avatar Jan 05 '18 18:01 r10s

I can reproduce this in 0.100, "BJ" finds "Björn" but "BJÖ" does not.

angelo-fuchs avatar Jan 25 '19 19:01 angelo-fuchs

i assume, this is a core-issue, moving it therefore. also i it is not limited to the contact search but also to chat and message search.

r10s avatar Jan 25 '19 19:01 r10s