I have a client that only supports Latin-1 and needs to connect to a
UTF-8 database to retrieve some data. Some columns may contain
characters that have no Latin-1 equivalent. I would like to convert
these to a blank or perhaps some hex value. Is there any way to do
this in PostgreSQL without using anything other than built in
functions or pl/pgsql? It would be nice if the built in convert
function had an option to handle this rather than only generating an
error. Any pointers to an existing pl/pgsql function to perform this
conversion?
Thanks,
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL