From: hernani <hernani@0cfe37f9-358a-4d5e-be75-b63607b5c754>
Date: Sat, 9 Apr 2011 02:26:46 +0000 (+0000)
Subject: Reverts the last commit, seems to cause some other issues.
X-Git-Tag: live~365
X-Git-Url: https://git.openstreetmap.org./osqa.git/commitdiff_plain/16f4e7502ed0b5a9774a98d27dac3de344902b23?hp=4501463a4b78c57303576dbbc5398721d5fa3cb5

Reverts the last commit, seems to cause some other issues.

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

diff --git a/forum/management/__init__.py b/forum/management/__init__.py
index 3da166e..629678e 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_general_ci NOT NULL;" % {
+            alter_table_statement = "ALTER TABLE %(table_name)s MODIFY %(column_name)s varchar(255) CHARACTER SET utf8 COLLATE utf8_bin 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)