Android sort sqlite query results ignoring case

just wondering if theres a way of sorting the results of a query ignoring case. Cause at the moment fields starting with an upper case letter are sorted and put on top of the list and fields starting with lower case letter are also sorted but are put after the upper case fields.

Thanks —

  • Creating an android smart app banner
  • Enable/Disable USB or Wifi tethering programmatically on android
  • Android Facebook lock screen notification
  • Android App Crashes Suddenly while running?
  • Having LLVM IR library how to crosscompile it to iOS, Android, Windows and Mac from Ubuntu?
  • Firebase Database - the “Fan Out” technique
  • Related posts:

    Android Calling JavaScript functions in WebView
    Using android MediaRecorder
    Open activity by clicking on the push notification from Parse
    Android Emulator starts but Eclipse doesn't recognize it
    Getview Called multiple times in android
    Custom format for relative time span
  • Android ListView's setOnItemClickListener from PopupWindow not called
  • How do I properly include an external jar file for a cordova plugin?
  • ScrollView - How to scroll down while designing layout in Eclipse?
  • Where can I find checkstyle config for Android Coding Style?
  • How to set ringtone in Android from my activity?
  • How to create a drop-down list?
  • 3 Solutions collect form web for “Android sort sqlite query results ignoring case”



    Convert all entries to lower case for example: select name from table order by LCASE(name)

    LCASE or LOWER (Check documentation)

    On the Android you are given a collation function called LOCALIZED.

    When you specify your column, do the following:


    It works great. If you have the Android source code, just do a search for “COLLATE” to see all sorts of examples.

    Android Babe is a Google Android Fan, All about Android Phones, Android Wear, Android Dev and Android Games Apps and so on.