charlie at egenix
Apr 30, 2007, 4:13 AM
Views: 1494
Permalink
|
|
Re: Unicode charset problems dealing with the ZmySQLDA product
[In reply to]
|
|
Am 30.04.2007, 12:33 Uhr, schrieb Miguel Sánchez Beato
<miguel.sanchez [at] iavante>:
> 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
--
Charlie Clark
eGenix.com
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
_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db
|
Re: Unicode charset problems dealing with the ZmySQLDA product