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 629678e70d94717c1a31dc59e03cf143556e79bb..3da166e2315543f32217708f79086fdc63f64ada 100644 (file)
--- 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)