diff options
| author | Bananeweizen <bananeweizen@gmx.de> | 2014-01-18 17:46:19 +0100 |
|---|---|---|
| committer | Bananeweizen <bananeweizen@gmx.de> | 2014-01-18 17:46:19 +0100 |
| commit | 215d18aba6b30fe5ccf295af57e6e420b85342ec (patch) | |
| tree | bc3f7f32fa35f4d522a626994ce4023ced544ab6 /main/src | |
| parent | 7efd77e24ec754feae378e0a6a3db550f8308772 (diff) | |
| download | cgeo-215d18aba6b30fe5ccf295af57e6e420b85342ec.zip cgeo-215d18aba6b30fe5ccf295af57e6e420b85342ec.tar.gz cgeo-215d18aba6b30fe5ccf295af57e6e420b85342ec.tar.bz2 | |
sort search suggestions case insensitive
Diffstat (limited to 'main/src')
| -rw-r--r-- | main/src/cgeo/geocaching/DataStore.java | 14 |
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); } |