[Zope-DB] Unicode charset problems dealing with the ZmySQLDA product

Charlie Clark charlie at egenix.com
Mon Apr 30 07:13:45 EDT 2007

Am 30.04.2007, 12:33 Uhr, schrieb Miguel Sánchez Beato  
<miguel.sanchez at iavante.es>:

> Hello. I'm dealing with the ZmySQLDA product on  Zope 2.9.7 and Python  
> 2.4.3 versions.
> I'm having problems when I retrieve data from the database because the  
> data is not rendered using the unicode charset when the zope instance is  
> in a vserver (with a Gentoo Linux distribution), so I get  weird  
> characters like 'á' instead of the usual ones: 'á' (as they are strored  
> inthe db). This is not happening on my local machine, so I guess it  
> could be a bad configuration of the vserver.
> Is there any possibilities to pass a parameter to the ZmySQLDSA  
> connection to make it use the unicode charset?
> Which differences are between the _mysql python module and the MySQLdb  
> library for this purpose?
> Could it be the configuation of the vserver? How can it be relationed  
> with the unicode problems?
> Any idea?

What setting do you have for Zope's encoding? in etc/zope.conf
Your problem might be solved with the correct setting for that. Otherwise  
you may need to patch the DA to handle encoding for your target for you.


Charlie Clark

Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::

     eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
     D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
            Registered at Amtsgericht Duesseldorf: HRB 46611

More information about the Zope-DB mailing list