Adding use_unicode=0 to the MySQL database connection string restores the behavior...

git-svn-id: http://www.winterrodeln.org/svn/servermediawiki/trunk/wradmin@617 7aebc617-e5e2-0310-91dc-80fb5f6d2477

diff --git a/wradmin/development.ini b/wradmin/development.ini
index ccfe1a58cdab918f745e6e7418698224cc26d05c..0239233d99625870d3ad274a87aaed3ee9ea3edc 100644 (file)
--- a/wradmin/development.ini
+++ b/wradmin/development.ini
@@ -36,7 +36,8 @@ authkit.basic.authenticate.user.data =
 #beaker.session.data_dir = %(here)s/data/sessions
 
 # SQLAlchemy database URL
-sqlalchemy.url = mysql://philipp@localhost:3306/winterrodeln_wiki?charset=utf8
+sqlalchemy.url = mysql://philipp@localhost:3306/winterrodeln_wiki?charset=utf8&use_unicode=0
+# If use_unicode=1, sqlalchemy requests unicode strings from the MySQLdb backend (and does not do the conversion itself), however, since the tables are defined as 'varchar(x) binary' only binary string are returned and not converted to unicode.
 # necessary for mySQL databases
 sqlalchemy.pool_recycle = 3600
 # sqlalchemy.echo_pool = 1

diff --git a/wradmin/wradmin/config/deployment.ini_tmpl b/wradmin/wradmin/config/deployment.ini_tmpl
index 095acad53e8cd03c45e7f96cc6a0b25fa6ffb817..d0fa0d431903ca595e4b3e1b4c769485a52a9be8 100644 (file)
--- a/wradmin/wradmin/config/deployment.ini_tmpl
+++ b/wradmin/wradmin/config/deployment.ini_tmpl
@@ -36,7 +36,7 @@ authkit.basic.authenticate.user.data =
 #beaker.session.data_dir = %(here)s/data/sessions
 
 # SQLAlchemy database URL
-sqlalchemy.url = mysql://user@localhost:3306/winterrodeln_wiki?charset=utf8
+sqlalchemy.url = mysql://user@localhost:3306/winterrodeln_wiki?charset=utf8&use_unicode=0
 # necessary for mySQL databases
 sqlalchemy.pool_recycle = 3600