Android SQLite Sort order does not work with upper and lowercase letters

If you are using SQLite database, with a Cursor or Perhaps Content provider, you may have come across alphabetical sorting problems regarding upper and lowercase letters. Perhaps you are requesting a cursor from a Content Provider: String[] projection = { Table.COLUMN_ID, Table.COLUMN_TITLE}; String sortOrder = Table.COLUMN_TITLE + " COLLATE NOCASE ASC"; CursorLoader cursorLoader = new CursorLoader(this, YourProvider.CONTENT_URI, projection, null, null, sortOrder); The solution to the alphabetical sorting problem is the COLLATE NOCASE in the part of the

» Read more

Android Emulator: How to access the sqlite database of an app

This is an example of how to access the sqlite database of an Android app running on an emulator. Make sure you have the android adb tool on your PATH. Run this command in the terminal: adb version If you have adb on your path, it should show something similar to this: Android Debug Bridge version 1.0.31 If not, follow this guide: Adding the adb tool to the terminal for easy access. Accessing the SQLITE database Open a

» Read more