[Pypgsql-users] unicode?

[Mark M. <ma...@mc...>]

Hi, I'm trying to insert unicode strings into PostgreSQL via PgSQL and I'm
having a devil of a time with it.  Here's what I tried:

$ createdb -E UNICODE testu
$ psql testu
# \encoding
UNICODE
# create table person (firstname text)
CREATE

So far so good.

So then I hop into Python and try:

>>> import PgSQL
>>> c = PgSQL.Connection("dbname=testu")
>>> cur = c.cursor()
>>> q = "insert into person (firstname) values (%s)"
>>> firstname = u'Mark'
>>> params = []
>>> params.append(firstname)
>>> cur.execute(q, params)
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/lib/python2.1/site-packages/PgSQL.py", line 2111, in execute
    raise OperationalError, msg
libpq.OperationalError: ERROR:  Unable to locate type name 'u' in catalog

Q:  How come this doesn't just work?

I wish I could ask a more intelligent question than that!

Thanks,

// mark