I have a database whose records are inserted via ODBC.
I turned on logging, and the client is explicitly setting the client encoding to UTF.
Rows are inserted into the tables. When I do a pg_dump, I do not get any errors. When I try tor restore, I am getting an error regarding an invalid UTF-8 character sequence.
Of course, this renders compressed backups useless, since I have no way of manually fixing the file. The process of fixing the file is, of course, painful.
Is this a known issue? I am running PG 8.1.4. The problem happened on PG Windows.
Tomorrow I will try to see if the problem exists in the FreeBSD compile. If I get it to reproduce, I will be able to send some data dumps, but will need to know who to send it to.
Regards,
Benjamin