| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Vishal Mailinglist <list(at)vishal(dot)net(dot)in> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: How to get rid of unicode |
| Date: | 2006-07-10 17:04:06 |
| Message-ID: | 86286FC6-C3A5-47CA-BD81-4D28FE16E8CB@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 thread for some ideas and solutions.
http://archives.postgresql.org/pgsql-general/2006-05/msg01457.php
It would be nice to have a built-in function to make a best effort
character conversion rather than generating errors.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KyLiE | 2006-07-10 21:55:40 | %Alter Help |
| Previous Message | Ivo Rossacher | 2006-07-10 16:52:42 | Re: How to get rid of unicode |