Kevin,
I managed to solve this problem by hacking turbogears/database.py
directly:
--- database.py (revision 411)
+++ database.py (working copy)
@@ -33,6 +33,8 @@
# and the cache causes problems with sqlite.
if self.uri.startswith("sqlite"):
TheURIOpener.cachedURIs = {}
+ if self.uri.startswith("mysql"):
+ conn.query('SET NAMES utf8')
self.threadingLocal.connection = conn
return self.begin(conn)
But what's next?
Should I file a ticket? Generalize the patch to allow 'db client
encoding' specified in the TG configuration files (that would result in
SET NAMES or other command for corresponding database)? File a bug
report to sqlobject?
Am I completely wrong dealing with this issue?
