Re: Character Encoding Question

On Thu, Mar 28, 2013 at 4:34 PM, Don Parris <parrisdc@gmail.com> wrote:
> Thanks Daniele,
>
> I'm using psycopg 2.4.5 with Python 3.2.3 on Kubuntu 12.10.
>
> This is the connection encoding based on a quick check at the Python
> console:
>>>>print(con.encoding)
> SQLASCII

In this case it's natural that you get an error on decode. But is it
really the database encoding? What does this query say:

    cur = con.cursor()
    cur.execute("show client_encoding")
    print cur.fetchone()[0]


> I honestly don't know where the error actually is - not a very advanced
> programmer by any means.  All I really know is that the program breaks when
> I use fetchall(), but it works with fetchone() and fetchmany().  It could
> have something to do with the way my main program module imports the module
> that calls the function, for all I know.  Here is the traceback:

I'll try to load your dataset and play with it, thank you.

-- Daniele