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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
