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 E6A739FB2BB for ; Mon, 10 Jul 2006 13:39:12 -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 00640-02 for ; Mon, 10 Jul 2006 13:39:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id 017D49FB259 for ; Mon, 10 Jul 2006 13:39:01 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id y25so705350nfb for ; Mon, 10 Jul 2006 09:39:00 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=JuWEcJNE9iRddThS+A9+UwyHVD9OaOKDkG3OF8c8TW2FHzP/nTVXfiWpABlu7CNM/dscyhnCzvEkKcKGKgwEbuuS8ilChcnwrvgH3lccW3CZ7hd+G8qrizUDXf2rdqxNsxcVDJeVuDviSa7ln9KL9mzoerSquuAcyDfx5+UEJ0M= Received: by 10.78.160.2 with SMTP id i2mr1770115hue; Mon, 10 Jul 2006 09:39:00 -0700 (PDT) Received: by 10.78.29.2 with HTTP; Mon, 10 Jul 2006 09:39:00 -0700 (PDT) Message-ID: Date: Mon, 10 Jul 2006 11:39:00 -0500 From: "Aaron Bono" To: "Vishal Mailinglist" Subject: Re: How to get rid of unicode Cc: pgsql-admin@postgresql.org In-Reply-To: <33632cf0607100247k1a1fdfd5l9041821fff5c26be@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_33857_25239602.1152549540045" References: <33632cf0607100247k1a1fdfd5l9041821fff5c26be@mail.gmail.com> X-Google-Sender-Auth: 2a5964d2f4f97ff0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/59 X-Sequence-Number: 22305 ------=_Part_33857_25239602.1152549540045 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/10/06, Vishal Mailinglist wrote: > > 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 > What are you converting it to? ASCII? ------=_Part_33857_25239602.1152549540045 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/10/06, Vishal Mailinglist <list@vishal.net.in> wrote:
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

What are you converting it to?  ASCII?

------=_Part_33857_25239602.1152549540045--