Hello! > -----Ursprüngliche Nachricht----- > Von: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Im Auftrag von Howard Cole > Gesendet: Dienstag, 6. Dezember 2005 13:41 > An: 'PgSql General' > Betreff: Re: [GENERAL] Unicode Corruption and upgrading to > 8.0.4. to 8.1 > >> Hi everyone, I have a problem with corrupt UTF-8 sequences in my > >> 8.0.4 dump which is preventing me from upgrading to 8.1 - > which spots > >> the errors and refuses to import the data. Is there some > SQL command > >> that I can use to fix or cauterise the sequences in the 8.0.4 > >> database before dumping to 8.1? > >> > >> I think the problem arose using invalid client encodings - > which were > >> not rejected prior to 8.1. We experienced the exact same problems. You may solve the problem by feeding the dump through iconv. See my earlier message on this issue http://archives.postgresql.org/pgsql-general/2005-11/msg00799.php On top of that you'd be well advised to try dumping using pg_dump of postgresql 8.1. Kind regards Markus
