[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