sort search suggestions case insensitive

1 files changed, 4 insertions, 10 deletions

diff --git a/main/src/cgeo/geocaching/DataStore.java b/main/src/cgeo/geocaching/DataStore.java
index 11c5a9a..f5af25e 100644
--- a/main/src/cgeo/geocaching/DataStore.java
+++ b/main/src/cgeo/geocaching/DataStore.java
@@ -3167,16 +3167,10 @@ public class DataStore {
     }
 
     public static String[] getSuggestions(final String table, final String column, final String input) {
-        Cursor cursor = database.query(
-                true,
-                table,
-                new String[] { column },
-                column + " LIKE ?",
-                new String[] { getSuggestionArgument(input) },
-                null,
-                null,
-                column,
-                null);
+        Cursor cursor = database.rawQuery("SELECT DISTINCT " + column
+                + " FROM " + table
+                + " WHERE " + column + " LIKE ?"
+                + " ORDER BY " + column + " COLLATE NOCASE ASC;", new String[] { getSuggestionArgument(input) });
         return getFirstColumn(cursor);
     }