[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