Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What does COLLATE LOCALIZED ASC stand for?

private Cursor getContacts() {     // Run query     Uri uri = ContactsContract.Contacts.CONTENT_URI;     String[] projection = new String[] {             ContactsContract.Contacts._ID,             ContactsContract.Contacts.DISPLAY_NAME     };     String selection = ContactsContract.Contacts.IN_VISIBLE_GROUP + " = '" +             (mShowInvisible ? "0" : "1") + "'";     String[] selectionArgs = null;     String sortOrder = ContactsContract.Contacts.DISPLAY_NAME +             " COLLATE LOCALIZED ASC";      return managedQuery(uri, projection, selection, selectionArgs, sortOrder); } 

What does COLLATE LOCALIZED ASC stand for?

like image 215
Pentium10 Avatar asked Mar 04 '10 16:03

Pentium10


1 Answers

Collate is just fancy speak for sort (well sort of). So this is sort ordering based on localized preferences (i.e. current language's alphabet and conventions) in ascending order.

like image 159
Kris Avatar answered Oct 02 '22 12:10

Kris