| From: | anil maran <anilmrn(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-www(at)postgresql(dot)org |
| Subject: | latin-1 to utf8 in python |
| Date: | 2006-08-02 19:26:12 |
| Message-ID: | 20060802192612.71752.qmail@web55915.mail.re3.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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', '(dot)(dot)(dot)(at)tad(dot)com'])
"); //-->
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-08-02 19:29:33 | Re: [Fwd: [BUGS] BUG #2560: Web page documentation hard |
| Previous Message | Richard Huxton | 2006-08-02 19:12:44 | Re: [Fwd: [BUGS] BUG #2560: Web page documentation hard |