It does work, using this branch, thank you.
One observation, the string returned is of type str, not unicode.
adapted = psycopg2.extensions.adapt(u'test')
On Sun, Jan 23, 2011 at 4:44 AM, Daniele Varrazzo
> On Sun, Jan 23, 2011 at 7:53 AM, Carl S. Yestrau Jr.
> <carl(at)featureblend(dot)com> wrote:
>> I'm currently using psycopg2.extensions.adapt without a connection
>> The following results in a: psycopg2.InterfaceError: can't encode
>> unicode string to latin-1
>> import psycopg2
>> adapted = psycopg2.extensions.adapt(u'test')
> You are right, it should work, and it works indeed in the psycopg dev
> version, but it looks broken in 2.3.2 and probably in previous
> I can see that the glitch happens when the adapter is not "prepared"
> for the connection: if you add that step it will work. Preparation
> always happens when the parameters are passed to the query.
> >>> cnn = psycopg2.connect('dbname=test')
> >>> adapted.prepare(cnn)
> >>> adapted.getquoted()
> Preparation is probably not mentioned in the docs at all: this is
> something else to review. If you are into writing an adapter, you may
> want to take a look to SQL_IN or the hstore adapter for complete
> If you need to work without the connection, do you want to try
> checking out my dev branch? I've just pushed it on
> -- Daniele
In response to
psycopg by date
|Next:||From: Daniele Varrazzo||Date: 2011-01-24 00:01:52|
|Subject: Psycopg porting to Python3: a report|
|Previous:||From: Daniele Varrazzo||Date: 2011-01-23 12:44:36|
|Subject: Re: getquoted and unicode|