Using COLLATE in Android SQLite – Locales is ignored in LIKE statement

by

Have you had a look at the SQLite documentation for LIKE? It has come information about non ASCII characters and a bug. Maybe Android has an older version of SQLite installed where this is a problem.

I think the second normalised column might be your best option unfortunately.

More Related Contents:

  1. Android SQLite data display to ListView
  2. Android :: SQLIte Db don't insert the datas
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. Android SQLite database: slow insertion
  5. Pros and Cons of SQLite and Shared Preferences [closed]
  6. Share SQLite database between 2 android apps?
  7. Android: upgrading DB version and adding new table
  8. How do I view the SQLite database on an Android device? [duplicate]
  9. Best way to work with dates in Android SQLite [closed]
  10. Android SQLite Example [closed]
  11. Android database encryption
  12. Best place to close database connection
  13. Import .csv file to Sqlite in Android
  14. Cursor adapter and sqlite example [closed]
  15. How to add new Column to Android SQLite Database?
  16. How to retrieve data from sqlite database in android and display it in TextView
  17. What is a Full Android Database Helper class for an existing SQLite database? [closed]
  18. How to save images into Database
  19. Android SQLite Database, WHY drop table and recreate on upgrade
  20. SQLite simultaneous reading and writing
  21. update sql database with ContentValues and the update-method
  22. How does one check if a table exists in an Android SQLite database?
  23. Create SQLite database in android
  24. Could not allocate CursorWindow
  25. Saving ArrayLists in SQLite databases
  26. android, how to exec a sql file in sqlitedatabase
  27. SQLiteOpenHelper – creating database on SD card
  28. How to store JSON object in SQLite database
  29. H2 Database vs SQLite on Android [closed]
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment