X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1C2639FB27A for ; Mon, 10 Jul 2006 06:47:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 62408-09 for ; Mon, 10 Jul 2006 06:47:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id 36D319FB26F for ; Mon, 10 Jul 2006 06:47:27 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id x30so361730nfb for ; Mon, 10 Jul 2006 02:47:26 -0700 (PDT) Received: by 10.49.64.9 with SMTP id r9mr3564215nfk; Mon, 10 Jul 2006 02:47:26 -0700 (PDT) Received: by 10.49.31.3 with HTTP; Mon, 10 Jul 2006 02:47:25 -0700 (PDT) Message-ID: <33632cf0607100247k1a1fdfd5l9041821fff5c26be@mail.gmail.com> Date: Mon, 10 Jul 2006 15:17:25 +0530 From: "Vishal Mailinglist" To: pgsql-admin@postgresql.org Subject: How to get rid of unicode MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_57241_31129416.1152524845882" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/51 X-Sequence-Number: 22297 ------=_Part_57241_31129416.1152524845882 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Dear All , I am reciving unicode text in one of the table field this actually breaks my frontend. I want to create a trigger which will actually detect a unicode character in the field and change/filter it out. How to go about this ? Regards, Vishal Kashyap. http://vishal.net.in ------=_Part_57241_31129416.1152524845882 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Dear All ,

I am reciving unicode text in one of the table field this actually breaks my frontend.
I want to create a trigger which will actually detect a unicode character in the field and change/filter it out.
How to go about this ?


Regards,
Vishal Kashyap.
http://vishal.net.in ------=_Part_57241_31129416.1152524845882--