Jump to content

Case insensitive search for non-Latin characters


Recommended Posts

  • 2 weeks later...
  • 3 months later...

But is it bug and need to be fixed. The clause of the bug not in Android settings, Android provides you sqlite3. Sqlite 3 supports UTF-8 and UTF-16, but doesn't works with case-insensitive LIKE and ORDER BY for characters that out of ASCII-range. I found a several ways to resolve this problem:

- ICU extension for sqlite3 (http://stackoverflow.com/questions/3944207/unicode-support-in-android-ndk)

- CursorWrapper (https://gist.github.com/ramzes642/5400792)
- Create additionally field for search and store therein lowercase'd text

 

Please don't forget for non-English users ;)

Link to post
Share on other sites
  • 5 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...