Re: [GENERAL] Unicode Corruption and upgrading to 8.0.4. to 8.1

2005-12-06 Thread Markus Wollny
Hi! > -Ursprüngliche Nachricht- > Von: Howard Cole [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 6. Dezember 2005 15:38 > An: Markus Wollny > Cc: PgSql General > Betreff: Re: [GENERAL] Unicode Corruption and upgrading to > 8.0.4. to 8.1 > I am avoiding thi

Re: [GENERAL] Unicode Corruption and upgrading to 8.0.4. to 8.1

2005-12-06 Thread Howard Cole
Thanks Markus, I am avoiding this solution at the moment since the database contains binary (ByteA) fields aswell as text fields and I am unsure what iconv would do to this data. If Zlatko's method does not work then I shall see if I can programmatically use libiconv for all the relevant data.

Re: [GENERAL] Unicode Corruption and upgrading to 8.0.4. to 8.1

2005-12-06 Thread Markus Wollny
Hello! > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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

Re: [GENERAL] Unicode Corruption and upgrading to 8.0.4. to 8.1

2005-12-06 Thread Howard Cole
Hi Zlatko, I shall give this a try later and let you know how I get on. Thank you for responding. Howard. Zlatko Matic wrote: Have you tried to restore just schema first, then data? Greetings, Zlatko Hi everyone, I have a problem with corrupt UTF-8 sequences in my 8.0.4 dump which is pre

Re: [GENERAL] Unicode Corruption and upgrading to 8.0.4. to 8.1

2005-12-04 Thread Zlatko Matic
Have you tried to restore just schema first, then data? Greetings, Zlatko - Original Message - From: "Howard Cole" <[EMAIL PROTECTED]> To: "'PgSql General'" Sent: Friday, December 02, 2005 3:02 PM Subject: [GENERAL] Unicode Corruption and upgradi

[GENERAL] Unicode Corruption and upgrading to 8.0.4. to 8.1

2005-12-02 Thread Howard Cole
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.