X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id E5BF7924E18 for ; Tue, 27 May 2003 16:55:43 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 94758-10 for ; Tue, 27 May 2003 16:55:42 -0400 (EDT) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by developer.postgresql.org (Postfix) with SMTP id 5F315924E06 for ; Tue, 27 May 2003 16:55:39 -0400 (EDT) Received: (qmail 6765 invoked from network); 27 May 2003 20:58:54 -0000 Received: from unknown (HELO trade-india.com) (unknown) by unknown with SMTP; 27 May 2003 20:58:54 -0000 Received: (qmail 5284 invoked by uid 505); 27 May 2003 20:55:06 -0000 Received: from mallah@trade-india.com by ns1.trade-india.com by uid 502 with qmail-scanner-1.16 (clamscan: 0.54. spamassassin: 2.54. Clear:SA:0(-98.1/5.0):. Processed in 0.497781 secs); 27 May 2003 20:55:06 -0000 X-Spam-Status: No, hits=-98.1 required=5.0 Received: from ns1.trade-india.com (HELO trade-india.com) (66.234.10.14) by ns1.trade-india.com with SMTP; 27 May 2003 20:55:06 -0000 Received: from 219.65.226.152 (SquirrelMail authenticated user mallah) by mail.trade-india.com with HTTP; Wed, 28 May 2003 02:25:06 +0530 (IST) Message-ID: <1140.219.65.226.152.1054068906.squirrel@mail.trade-india.com> Date: Wed, 28 May 2003 02:25:06 +0530 (IST) Subject: Getting rid of accents.. From: To: X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal X-Mailer: SquirrelMail (version 1.2.6) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/527 X-Sequence-Number: 13692 Is there any easy way for converting accented text to closest text without accents in postgresql ? eg: BĀLĀ MORGHĀB to BALA MORGHAB Regds Mallah. ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/