latin-1 to utf8 in python - Mailing list pgsql-www

From anil maran
Subject latin-1 to utf8 in python
Date
Msg-id 20060802192612.71752.qmail@web55915.mail.re3.yahoo.com
Whole thread Raw
In response to Re: [Fwd: [BUGS] BUG #2560: Web page documentation hard  (Richard Huxton <dev@archonet.com>)
Responses Re: latin-1 to utf8 in python  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-www
postgres takes utf8
pls help me solve this thanks a lot
some data is in latin-1 so postgres
crashes
with
psycopg2.ProgrammingError at /todo/38
invalid byte sequence for encoding "UTF8": 0x92
ariable         Value
args
("INSERT INTO xdaad(nt, nn, tadadid, email) VALUES (%s, %s, %s, %s); SELECT
currval('comments_id_seq')", ['co-worker\x92snd I\x92ll get the .\r\n\r\n \r\n\r\nAeF\r\n\r\n\r\n\r\n \r\n\r\n', '121', '38', '...@tad.com'])


Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.

pgsql-www by date:

Previous
From: Richard Huxton
Date:
Subject: Re: [Fwd: [BUGS] BUG #2560: Web page documentation hard
Next
From: Tom Lane
Date:
Subject: Re: [Fwd: [BUGS] BUG #2560: Web page documentation hard