Re: [SQLObject] unicode string in queries - a bug?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Stuart B. <st...@st...> - 2006-01-30 04:41:08
|
Oleg Broytmann wrote: > On Thu, Jan 19, 2006 at 12:40:46PM +0200, Max Ischenko wrote: > >>Hello, >> >>It seems that SQLObject doesn't allow unicode string when running SQL statements, specifically to specify values for UnicodeCol keys. OTOH, when creating an object, unicode strings is accepted and converted properly into needed encoding, like utf-8. >> >>Is it a bug or I'm doing something wrong? > > > Neither. It's a misdesign. It lies so deeply in SQLObject it is hard to > fix it with a short patch. > > Do cls.selectBy(that_unicode_col=u'some string'.encode(dbEncoding)) > > Oleg. We handle this quite simply by encoding the entire query before sending it to the database and making SQLObject not encode any strings until that point. And if the driver accepts Unicode strings natively, you don't have to do *any* encoding. -- Stuart Bishop <st...@st...> http://www.stuartbishop.net/ |