How to ignore accent in SQLite query (Android)

by

Generally, string comparisons in SQL are controlled by column or expression COLLATE rules. In Android, only three collation sequences are pre-defined: BINARY (default), LOCALIZED and UNICODE. None of them is ideal for your use case, and the C API for installing new collation functions is unfortunately not exposed in the Java API.

To work around this:

  1. Add another column to your table, for example MOVIE_NAME_ASCII

  2. Store values into this column with the accent marks removed. You can remove accents by normalizing your strings to Unicode Normal Form D (NFD) and removing non-ASCII code points since NFD represents accented characters roughly as plain ASCII + combining accent markers:

    String asciiName = Normalizer.normalize(unicodeName, Normalizer.Form.NFD)
    .replaceAll("[^\\p{ASCII}]", "");

  3. Do your text searches on this ASCII-normalized column but display data from the original unicode column.

More Related Contents:

  1. Unable to save and retrieve String data using Sqlite in android
  2. Why does the application crash when I press the button to insert the values in the table? [duplicate]
  3. Pros and Cons of SQLite and Shared Preferences [closed]
  4. Share SQLite database between 2 android apps?
  5. Android column ‘_id’ does not exist?
  6. Android: upgrading DB version and adding new table
  7. How do I view the SQLite database on an Android device? [duplicate]
  8. Android P – ‘SQLite: No Such Table Error’ after copying database from assets
  9. Deleting Row in SQLite in Android
  10. Store Android SQLite
  11. Backup and restore SQLite database to sdcard
  12. Why do I get a “sqlite3: not found” error on a rooted Nexus One when I try to open a database using the adb shell?
  13. Cursor adapter and sqlite example [closed]
  14. Android sqlite how to check if a record exists
  15. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  16. SQLite Exception no such column when trying to select
  17. android java.lang.IllegalStateException: Couldn’t read row 0, col 0 from CursorWindow
  18. How can I insert image in a sqlite database
  19. Android Save images to SQLite or SDCard or memory
  20. What is The use of moveToFirst () in SQLite Cursors
  21. Create SQLite database in android
  22. Android SQLite auto increment
  23. Android Device Monitor “data” folder is empty
  24. How to check database on not rooted android device
  25. How to store JSON object in SQLite database
  26. sqlite3: not found
  27. Android SQLiteOpenHelper cannot open database file
  28. Getting the type of a column in SQLite
  29. Android table creation Failure (near “autoincrement”: syntax error)?
  30. sqlite insert into table select * from

Leave a Comment