> 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
