Contacts UPPERCASE followed by lowercase

Question

I am trying to extract a list of contacts from Android, the list returns correctly. The returned list is sorted in alphabetical order however the upper case letters are first followed by the lower case characters. Example. ABCDEFGHIJ.....abcdef

The following is the cursor I am using:

Cursor cursor = contentResolver.query(CONTENT_URI, null,null, null, "display_name ASC");

is this perhaps you are trying to achieve? http://stackoverflow.com/questions/2413427/how-to-use-sql-order-by-statement-to-sort-results-case-insensitive — vims liu, Jul 11 '16 at 08:53
@vims-liu yes that is correct, how would I achieve that in Android — the_big_blackbox, Jul 11 '16 at 08:57
perhaps you could try to change the order by param into this? — vims liu, Jul 11 '16 at 08:58
display_name COLLATE NOCASE ASC please let me know if this helps — vims liu, Jul 11 '16 at 08:58
you could also try the solution provided here: http://stackoverflow.com/questions/12566207/how-do-i-make-a-case-insensitive-query-with-contentresolver-in-android using lower cast — vims liu, Jul 11 '16 at 09:02
thanks @vims-liu the 'display_name COLLATE NOCASE ASC' worked boss... add your answer below lets get you some rep points.. — the_big_blackbox, Jul 11 '16 at 09:37

score 4 · Accepted Answer · answered Jul 11 '16 at 09:39

4

use display_name COLLATE NOCASE ASC to order the record case insensitive.

answered Jul 11 '16 at 09:39

vims liu

643
1
9
20

score 0 · Answer 2 · answered Jun 19 '20 at 09:21

Use My code

 private void getContactList() {
    ContentResolver cr = getContentResolver();

    Cursor cursor = cr.query(ContactsContract.CommonDataKinds.Phone.CONTENT_URI, PROJECTION, null, null,
            "display_name COLLATE NOCASE ASC");
    if (cursor != null) {
        HashSet<String> mobileNoSet = new HashSet<String>();
        try {
            final int nameIndex = cursor.getColumnIndex(ContactsContract.Contacts.DISPLAY_NAME);
            final int numberIndex = cursor.getColumnIndex(ContactsContract.CommonDataKinds.Phone.NUMBER);

            String name, number;
            while (cursor.moveToNext()) {
                name = cursor.getString(nameIndex);
                number = cursor.getString(numberIndex);
                number = number.replace(" ", "");
                if (!mobileNoSet.contains(number)) {
                    contactList.add(new Contact(name, number));
                    mobileNoSet.add(number);
                }
            }
        } finally {
            cursor.close();
        }
    }
}

Contacts UPPERCASE followed by lowercase

2 Answers2