--- a/roundup/backends/rdbms_common.py	Mon Mar 24 02:56:30 2003 +0000
+++ b/roundup/backends/rdbms_common.py	Mon Mar 24 04:47:44 2003 +0000
@@ -1,4 +1,4 @@
-# $Id: rdbms_common.py,v 1.47 2003-03-21 04:02:13 richard Exp $
+# $Id: rdbms_common.py,v 1.48 2003-03-24 04:47:44 richard Exp $
 ''' Relational database (SQL) backend common code.
 
 Basics:
@@ -1718,7 +1718,7 @@
             args.append(requirements[propname].lower())
 
         # generate the where clause
-        s = ' and '.join(['_%s=%s'%(col, self.db.arg) for col in where])
+        s = ' and '.join(['lower(_%s)=%s'%(col, self.db.arg) for col in where])
         sql = 'select id from _%s where %s'%(self.classname, s)
         self.db.sql(sql, tuple(args))
         l = [x[0] for x in self.db.sql_fetchall()]