how do I sort the retrieved data from the database to be displayed as the testing data listed below if there are special characters as the à character?
- Apple
- ÃTest
- Ãbc
Currently this is what I have
query(mDBOpenHelper.getReadableDatabase(), columnList,selection,selectionArgs, null, null, TestDBOpenHelper.COLUMN1)
When I tested the it on my device, it will display those below after the alphabet Z.
- ÃTest
- Ãbc
Could someone please teach me how do I fix this? thank you very much