From b093b34eb743baa3f020b718af97aef11ecfc58e Mon Sep 17 00:00:00 2001 From: Oguz Kocer Date: Mon, 23 May 2016 13:49:56 +0300 Subject: Changes people sorting to be case-insensitive --- WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java') diff --git a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java index a45784d51..05ea31807 100644 --- a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java +++ b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java @@ -94,7 +94,7 @@ public class PeopleTable { List people = new ArrayList<>(); String[] args = { Integer.toString(localTableBlogId) }; Cursor c = getReadableDb().rawQuery("SELECT * FROM " + PEOPLE_TABLE + - " WHERE local_blog_id=? ORDER BY display_name, user_name", args); + " WHERE local_blog_id=? ORDER BY lower(display_name), lower(user_name)", args); try { while (c.moveToNext()) { -- cgit v1.2.3