[Zope-DB] ZMySQLDA and utf-8

Wolfram Kraus kraus at hagen-partner.de
Tue Mar 1 03:55:02 EST 2005


Heyho!

Python 2.3.4 - Zope 2.7.4 - MySQLdb 1.2.0 - ZMySQLDA 2.0.8 or 2.0.9b2

How do I set ZMySQLDA to permanently use utf-8 as client character set?
When I insert the line "self.db.query('set character set utf8')" in 
db.DB.__init__() everything works fine ("show variables like '%char%'" 
in the test-tab of ZMySQLDA) until I restart MySQL, which resets the 
client character set to latin-1. The only solution to set the character 
set permanently is to do this in _begin().
Is this recommended or is there another solution?

TIA,
Wolfram



More information about the Zope-DB mailing list