=== modified file 'dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java' --- dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2014-06-14 07:44:15 +0000 +++ dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2014-06-14 17:08:42 +0000 @@ -337,7 +337,7 @@ final String col = statementBuilder.columnQuote( item.getItemId() ); sql += - "lower(" + col + ".value) " + regexp + " '" + wordStart + + col + ".value " + regexp + " '" + wordStart + StringUtils.lowerCase( query ) + wordEnd + "' or "; }