X-Original-To: pgsql-www-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 22AFB9FB228
	for <pgsql-www-postgresql.org@postgresql.org>;
	Wed,  2 Aug 2006 16:26:30 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 19161-03 for <pgsql-www-postgresql.org@postgresql.org>;
	Wed,  2 Aug 2006 19:26:15 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from web55915.mail.re3.yahoo.com (web55915.mail.re3.yahoo.com
	[216.252.110.76])
	by postgresql.org (Postfix) with SMTP id AF8EF9FA6A2
	for <pgsql-www@postgresql.org>; Wed,  2 Aug 2006 16:26:14 -0300 (ADT)
Received: (qmail 71754 invoked by uid 60001); 2 Aug 2006 19:26:12 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=fIaZqQbY5AFlqrbPuiz7hllC1b8jTQF+9Z6AYbRfrW6Xx4rfbaMkufcTgUXZNbywZUVJH7FuLe5aNtelD0merLNIJmAlXQknoLg7PfwiadlDsXrqNUl1KXHl7FEqhmS8P69pYQO0i2jerf3UnfsQdp3yi5NdkFn6UFULg/q0NhQ=
	;
Message-ID: <20060802192612.71752.qmail@web55915.mail.re3.yahoo.com>
Received: from [24.6.248.9] by web55915.mail.re3.yahoo.com via HTTP;
	Wed, 02 Aug 2006 12:26:12 PDT
Date: Wed, 2 Aug 2006 12:26:12 -0700 (PDT)
From: anil maran <anilmrn@yahoo.com>
Subject: latin-1 to utf8 in python
To: pgsql-www@postgresql.org
In-Reply-To: <44D0F92C.7030507@archonet.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-884730143-1154546772=:54851"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.951 tagged_above=0 required=5 tests=HTML_50_60,
	HTML_MESSAGE, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL
X-Spam-Level: ***
X-Archive-Number: 200608/15
X-Sequence-Number: 10406

--0-884730143-1154546772=:54851
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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.
--0-884730143-1154546772=:54851
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div>postgres takes utf8 <br></div><div>pls help me solve this thanks a lot<br></div><div> some data is in latin-1 so postgres <br> crashes <br> with <br> </div><div>psycopg2.ProgrammingError at /todo/38 <br> invalid byte sequence for encoding "UTF8": 0x92 <br> </div><div>ariable &nbsp; &nbsp; &nbsp; &nbsp; Value <br> args <br> ("INSERT INTO xdaad(nt, nn, tadadid, email) VALUES (%s, %s, %s, %s); SELECT <br> 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', '<a target="_parent" href="http://groups.google.com/groups/unlock?msg=ead2077185e3de4c&amp;_done=/group/webpy/browse_thread/thread/22297f1549fc41b2/ead2077185e3de4c">...</a>@tad.com']) <br>   </div>         <a class="on" href="http://groups.google.com/group/webpy/browse_thread/thread/22297f1549fc41b2/ead2077185e3de4c#" onclick="return rl('ead2077185e3de4c');" id="loead2077185e3de4c"><script language="javascript1.2"><!--   document.write("<img
 id=tiead2077185e3de4c border=0 src=\"/groups/img/r.gif\" height=11 width=11 alt=\"\">");   //--></script></a><p>&#32;
		<hr size=1>Yahoo! Messenger with Voice. <a href="http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com">Make PC-to-Phone Calls</a> to the US (and 30+ countries) for 2¢/min or less.
--0-884730143-1154546772=:54851--