Re: [Sqlalchemy-users] Encoding problem

2006-03-01 Thread Michael Bayer
On Mar 1, 2006, at 7:30 PM, Valentino Volonghi aka Dialtone wrote: assuming the current conversion-in-python works, does that get the job done for us ? or is there some advantage to psycopg's extension that we're missing out on ? Yes it works now, I tried inserting japanese text. The

Re: [Sqlalchemy-users] Encoding problem

2006-03-01 Thread Valentino Volonghi aka Dialtone
On Wed, 1 Mar 2006 19:10:21 -0500, Michael Bayer <[EMAIL PROTECTED]> wrote: good call, i just committed that. great! does: psycopg2.extensions.register_type(psycopg2.extensions.UNICODE) turn on unicode globally ? In psycopg2, yes. assuming the current conversion-in-python works,

Re: [Sqlalchemy-users] Encoding problem

2006-03-01 Thread Michael Bayer
On Mar 1, 2006, at 5:00 PM, Valentino Volonghi aka Dialtone wrote: On Wed, 1 Mar 2006 16:24:02 -0500, Michael Bayer <[EMAIL PROTECTED]> wrote: wow, i wish you had told me this yesterday, when i was asking if psycopg can handle unicode (on irc ? not sure where that was). anyway, theres a

Re: [Sqlalchemy-users] Encoding problem

2006-03-01 Thread Valentino Volonghi aka Dialtone
On Wed, 1 Mar 2006 16:24:02 -0500, Michael Bayer <[EMAIL PROTECTED]> wrote: wow, i wish you had told me this yesterday, when i was asking if psycopg can handle unicode (on irc ? not sure where that was). anyway, theres a ticket that I "fixed" by allowing the "convert_unicode" flag to Engine

Re: [Sqlalchemy-users] Encoding problem

2006-03-01 Thread Michael Bayer
wow, i wish you had told me this yesterday, when i was asking if psycopg can handle unicode (on irc ? not sure where that was). anyway, theres a ticket that I "fixed" by allowing the "convert_unicode" flag to Engine which will do the native utf-8 <-> binary encoding in and out of any engin

[Sqlalchemy-users] Encoding problem

2006-03-01 Thread Valentino Volonghi aka Dialtone
Hi all. Today I run into a problem with encoding and sqlalchemy... This is a very big topic and it's not sqlalchemy's fault (but rather the linuxbox fault is not configured to have UTF-8 as default encoding). But still... Here comes the problem: I'm trying to insert a like like the following: