From c342b278b84b59165b04419515c16bff944a44e2 Mon Sep 17 00:00:00 2001
From: Bananeweizen <bananeweizen@gmx.de>
Date: Sun, 18 Aug 2013 10:16:34 +0200
Subject: fix #3139: Search by geocode is case sensitive

---
 main/src/cgeo/geocaching/cgData.java | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

(limited to 'main/src')

diff --git a/main/src/cgeo/geocaching/cgData.java b/main/src/cgeo/geocaching/cgData.java
index 62e6664..f7b52e0 100644
--- a/main/src/cgeo/geocaching/cgData.java
+++ b/main/src/cgeo/geocaching/cgData.java
@@ -2743,8 +2743,6 @@ public class cgData {
 
     /**
      * checks if this is a newly created database
-     *
-     * @return
      */
     public static boolean isNewlyCreatedDatebase() {
         return newlyCreatedDatabase;
@@ -2757,6 +2755,10 @@ public class cgData {
         newlyCreatedDatabase = false;
     }
 
+    /**
+     * Creates the WHERE clause for matching multiple geocodes. This automatically converts all given codes to
+     * UPPERCASE.
+     */
     private static StringBuilder whereGeocodeIn(Set<String> geocodes) {
         final StringBuilder where = new StringBuilder();
 
@@ -2766,7 +2768,7 @@ public class cgData {
                 if (all.length() > 0) {
                     all.append(',');
                 }
-                all.append(DatabaseUtils.sqlEscapeString(geocode));
+                all.append(DatabaseUtils.sqlEscapeString(StringUtils.upperCase(geocode)));
             }
 
             where.append("geocode in (").append(all).append(')');
-- 
cgit v1.1