On 2011-01-24, Geoffrey Myers <lists@xxxxxxxxxxxxxxxxxxxxx> wrote: > Adrian Klaver wrote: > Thanks for the suggestion. As it stands, we are getting different > errors for different hex characters, thus the solution we need is the > ability to identify the characters that won't convert from SQL_ASCII to > UTF8. Is there a resource that would identify these characters? use "iconv" to strip out the invalid chacaters from the SQL and then compare before and after. I think the iconv command is iconv -f UTF8 -t UTF8 -c -- ââ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general