> 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?
It should be easy to write user defined funtion and define your own
CONVERSION. CREATE CONVERSION is your friend.
--
Tatsuo Ishii
SRA OSS, Inc. Japan