Signal-android: Upper- and lowercase accentuated characters are considered different when searching for a contact

[breversa]

• [x] I have searched open and closed issues for duplicates
  

---

Bug Description

As in the title : when either searching for a term in a conversation, or a recipient to send a message to, accentuated uppercase charactres (e.g. "É") are considered different than the same accentuated but lowercase character (e.g. "é").

Language is french.

Steps to Reproduce

1. Open Signal
2. Tap the "Search field"
3. Type (for instance) "éric"

Actual Result:

My contact "Éric" is not shown.

Expected Result:

My contact "Éric" is shown.
I need to explicitely type "Éric" (or "ÉRIC", or any other upper/lowercase combination except for "É")
Also, typing "eric" or "Eric" or "ERIC" (etc.) should also display "Éric".

Screenshots

Platform Info

Signal Version:

Signal 4.52.4
Not sure about Signal Desktop.

Operating System:

Android 9 (LineageOS 16)

Linked Device Version:

Link to Debug Log

[pericleskb]

This must have to do with SQLite. As it says here https://www.sqlite.org/lang_expr.html#like

SQLite only understands upper/lower case for ASCII characters by default. The LIKE operator is case sensitive by default for unicode characters that are beyond the ASCII range. For example, the expression 'a' LIKE 'A' is TRUE but 'æ' LIKE 'Æ' is FALSE.

[i7u]

TL;DR is that search is case sensitive for non-ASCII characters.

This bug occurs for any non-ASCII search term, breaking search in most non-English languages. Seeing the same with non-accented characters.

[waazdakka]

Hello,
Is there a chance to intergrate this fix into the search system ?
It will improve A LOT the usability in french (at least)
Thanks !

[second-reality]

I tried to notify dev who closed this MR so he can integrate this as well:

https://github.com/signalapp/Signal-Android/pull/9692#issuecomment-727223772

Indeed, that would make contact search much more usable in french (and any language with accented names).