On Nov 13, Davide Alberani <[EMAIL PROTECTED]> wrote:

> The fact is: with my MySQL 5.0.18 and the latest SQLObject, even
> a query like:
>   res = Name.select(Name.q.name == u'Bj\xf6rk') # the icelandic singer.
>   res.count()
> 
> fails with a UnicodeDecodeError.

A step in the direction of the right solution: install the latest
version of MySQL-python, and add use_unicode=1 and sqlobject_encoding='utf8'
as parameters when setting the connection.

These changes are already in the CVS; I've still to test if/how they
affect performances and usage with other db servers (well... I'm not
that optimist about performances...)

-- 
Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47]
http://erlug.linux.it/~da/

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel

Reply via email to