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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to