Hi,

Is it possible to return a cursor using SQLiteDatabase's 'query' methods that sorts items regardless of case?

I'm currently returning a list of:

Apple
Banana
apple
banana

done by the following means:

Code: Select all

String sortField = "FIELD1";
String sortDir = " ASC"; //or desc

return db.query(DATABASE_TABLE, new String[] {ID_FIELD, FIELD1, FIELD2}, null, null, null, null, sortField + sortDir);


which would be better as:

Apple
apple
Banana
apple

Cheers,
Steve

select * from items order by upper(title)

Thanks nmc, I've just tried using the db.rawQuery() to use an "ORDER BY title COLLATE NOCASE" which seems to work fine.

I will give your method a try as it looks a look cleaner than having a full SQL statement in the db.rawQuery.