X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/57036ac147a3759cda54aefa125697c16b991cbb..4501463a4b78c57303576dbbc5398721d5fa3cb5:/forum/management/__init__.py

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)