[Zope] Zope utf-8 problem using MySQL

Hugo Ramos ramosh at gmail.com
Wed Mar 19 14:11:27 EDT 2008


Yellow ppl,

I'm using Zope 2.10.5 + MySQL 5.0.51a + MySQL-python-1.2.2.

Everything is set to utf-8.
In MySQL server and client is set to utf-8 and utf8_general_ci
In Zope zpublisher is set to utf-8
I even created the (in)famous sitecustomize.py in Python 2.4.4 site-packages

The problem is that when retrieving data from a table the
international chars become alien symbols...

The only way I get the right symbols is using SET NAMES 'utf8'
<dtml-var sql_delimiter> on top of each sql method.

What am I missing?


Thanks

-- 
Hugo Ramos
http://www.hugoramos.eu/
ramosh at gmail.com


More information about the Zope mailing list