Re: Trouble with Mixed UTF-8 and Latin1 data

valgog wrote:
I know it looks like a mess

Indeed, that is what client encoding is for :)

> One idea is to write the function, that will normalize the data to
> UTF-8 in PL/pgSQL (that I could not do from the first try)

You could use convert(), iterate over the rows and catch the exceptions
in pl/pgsql.

http://www.postgresql.org/docs/8.3/interactive/functions-string.html
http://www.postgresql.org/docs/8.3/interactive/plpgsql-control-structures.html


--
Best regards,
Hannes Dorbath