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
