Re: getquoted and unicode - Mailing list psycopg

From Daniele Varrazzo
Subject Re: getquoted and unicode
Date
Msg-id AANLkTinhOJXya2+jXm04B6U7=3QhtKy-1MD-xVnx0v27@mail.gmail.com
Whole thread Raw
In response to Re: getquoted and unicode  ("Carl S. Yestrau Jr." <carl@featureblend.com>)
List psycopg
On Sun, Jan 23, 2011 at 5:17 PM, Carl S. Yestrau Jr.
<carl@featureblend.com> wrote:
> It does work, using this branch, thank you.

This will likely be included in the next release.

> One observation, the string returned is of type str, not unicode.
>
> Example:
> import psycopg2
> psycopg2.extensions.register_type(psycopg2.extensions.UNICODE)
> adapted = psycopg2.extensions.adapt(u'test')
> print adapted.getquoted()
> #<type 'str'>

Yes, this is what expected. Adaptation is taking a Python object and
converting it into a SQL representation: this is always a bytes
string, as it has to be sent to the socket.

-- Daniele

psycopg by date:

Previous
From: Daniele Varrazzo
Date:
Subject: Re: Psycopg porting to Python3: a report
Next
From: Nicolas Grilly
Date:
Subject: copy_from does not stop reading after an error