John DeSoi wrote:
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?
You should be able to do this with regular expressions (substituting all
invalid chars) on the text columns of the result set(s). I write "should
be", since I don't remember the capabilities of pg regular expressions.
/Nis
