From 215d18aba6b30fe5ccf295af57e6e420b85342ec Mon Sep 17 00:00:00 2001
From: Bananeweizen <bananeweizen@gmx.de>
Date: Sat, 18 Jan 2014 17:46:19 +0100
Subject: sort search suggestions case insensitive

---
 main/src/cgeo/geocaching/DataStore.java | 14 ++++----------
 1 file changed, 4 insertions(+), 10 deletions(-)

(limited to 'main/src/cgeo/geocaching/DataStore.java')

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);
     }
 
-- 
cgit v1.1