Commits

Anonymous committed 009c860

0.11-stable: Make sure MySQL uses a case insensitive collation for LIKE searches, re #8424.

Comments (0)

Files changed (1)

trac/db/mysql_backend.py

         return 'concat(%s)' % ', '.join(args)
 
     def like(self):
-        return "LIKE %s ESCAPE '/'"
+        return "LIKE %s COLLATE utf8_general_ci ESCAPE '/'"
 
     def like_escape(self, text):
         return _like_escape_re.sub(r'/\1', text)