Re: [SQLObject] Unicode handling with sqlobject's UnicodeCol?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Simon C. <hod...@gm...> - 2007-02-21 14:25:08
|
On 2/21/07, Oleg Broytmann <ph...@ph...> wrote: > I don't think a problem with the program is in unicode itself. I suspect > the problem is in "unicode-insisting" version of MySQLdb. There have to be > a proper charset/encoding set, and there have to be a proper handling of > them in SQLObject's MySQLConnection (and I am not sure how good that is, > though there is a constant stream of patches from MySQL users...) Agreed, with MySQL you'll definitely need to use the sqlobject_encoding parameter in the datbase connection URI. I'm currently using non-ASCII characters and UnicodeString columns without problems on MySQL 5 with a connection string like: mysql://user:pass@host/dbname/?sqlobject_encoding=latin1 I've gotten the impression that with MySQL 4 one is unlikely to have much luck (haven't tested it myself). Schiavo Simon |