From: hernani <hernani@0cfe37f9-358a-4d5e-be75-b63607b5c754>
Date: Sat, 9 Apr 2011 02:20:55 +0000 (+0000)
Subject: Use a collation on tag and user names that allows case insensitive search.
X-Git-Tag: live~366
X-Git-Url: https://git.openstreetmap.org./osqa.git/commitdiff_plain/4501463a4b78c57303576dbbc5398721d5fa3cb5

Use a collation on tag and user names that allows case insensitive search.

git-svn-id: http://svn.osqa.net/svnroot/osqa/trunk@946 0cfe37f9-358a-4d5e-be75-b63607b5c754
---

diff --git a/forum/management/__init__.py b/forum/management/__init__.py
index 629678e..3da166e 100644
--- a/forum/management/__init__.py
+++ b/forum/management/__init__.py
@@ -29,7 +29,7 @@ def post_syncdb_callback(sender, **kwargs):
 
         # Update each column in turn.
         for table_name, column_name in updatable_table_columns.iteritems():
-            alter_table_statement = "ALTER TABLE %(table_name)s MODIFY %(column_name)s varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;" % {
+            alter_table_statement = "ALTER TABLE %(table_name)s MODIFY %(column_name)s varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;" % {
                 "table_name": table_name, "column_name": column_name}
             log_status(verbosity,"Updating MySQL column with this statement: " + alter_table_statement)
             cursor.execute(alter_table_statement)