Re: [ADMIN] How to get rid of unicode

2006-07-10 Thread Aaron Bono
On 7/10/06, Vishal Mailinglist <[EMAIL PROTECTED]> 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

Re: [ADMIN] How to get rid of unicode

2006-07-10 Thread John DeSoi
On Jul 10, 2006, at 5:47 AM, Vishal Mailinglist wrote: 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 ? See this t

Re: [ADMIN] How to get rid of unicode

2006-07-10 Thread Ivo Rossacher
You can ask the server to translate everything to the needed encoding by setting the clientencoding correctly (if you do not have SQLASCII as server encoding, otherwise think about fixing this issue by selecting a reasonable server encoding for your application). Example : set client_encoding='L

[ADMIN] How to get rid of unicode

2006-07-10 Thread Vishal Mailinglist
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