Re: [Zope-DB] Unicode charset problems dealing with the ZmySQLDA product
Miguel Sánchez Beato wrote at 2007-4-30 12:33 +0200:
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).
Strictly speaking, there is no Unicode charset.
Apparently something in your data flow uses the utf-8 charset
but your pages do not tell this to the browser.
You may try to set an
response.setHeader('Content-Type', 'text/html; charset=utf-8).
...
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?
Often the database configuration or some environment variable
determine the so called client encoding. The client encoding
controls which encoding (aka charset) the client expects for
unicode strings.
There may be differences between your two configurations.
--
Dieter
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?
--On 26. März 2007 22:49:21 +0200 Maciej Wisniowski [EMAIL PROTECTED] wrote: My posting says *nothing* about deprecating something. So __please__ stop reading between the lines when there is nothing - except whitespaces. But you said about *replacing* all different zope DAs. So I think it is not reading between lines. I agree that this kind of adapter (as additional one) is a nice idea :) For all who might be interested: there is now something like that called SQLAlchemyDA: http://svn.zope.org/Products.SQLAlchemyDA/trunk/ It uses my z3c.sqlalchemy implementation. The code quality is still alpha but good enough to let it work with ZSQL methods (but only roughly tested). Feedback welcome! Andreas pgpS94MllJA2u.pgp Description: PGP signature ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Seeking a suitable psycopgDA
I'm looking for the right version of psycopgDA for the following setup: Windows XP PostgreSQL 8.0 Zope 2.9.6-final Plone 2.5.2 (don't know if that matters) Python 2.4.3 Psycopg = win-psycopg24-pg8.0.zip downloaded from http://stickpeople.com/projects/python/win-psycopg/ MX Toolkit = egenix-mx-base-2.0.6.win32-py2.4.exe downloaded from http://www.egenix.com/files/python/eGenix-mx-Extensions.html I would hope to get the psycopgDA in binary or .msi form, or just as files I can dump into a directory, as I'm really not set up to compile and build stuff. Can you tell me where to find it? ~ TIA ~ Ken ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
