Py-postgre SQL Encoding issue

[James William Pye]

On Aug 14, 2009, at 11:36 AM, Franklin, Peter wrote:
>>>>> db = postgresql.connect("pq://xxxx:xxxx@localhost:5843/vnes")

The quick solution is to set the client_encoding in the connect string:

  db = postgresql.connect("pq://xxx:xxx:@localhost:5843/vnes? 
client_encoding=utf-8")


>> LookupError: unknown encoding: WIN1252

k, I'll look into getting an appropriate alias setup.
That is, hoping that Python supports that encoding...

>> Any suggestions on what I may need to do here to get this working?

If possible, I'd suggest initializing the database cluster with utf-8.