Re: pg_restore failes - invalid byte sequence for encoding "UNICODE": 0xa3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ofuerst(at)tsak(dot)net
Cc: Agent M <agentm(at)themactionfaction(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: pg_restore failes - invalid byte sequence for encoding "UNICODE": 0xa3
Date: 2006-07-17 15:16:47
Message-ID: 3528.1153149407@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ofuerst(at)tsak(dot)net writes:
> As I wrote in my initial posting: source and target encoding is UNICODE. I can
> restore mentioned backups without a problem on a Windows host. And every backup
> I take is not restore-able on it's original host...

Indeed, 8.0.8 is stricter about encoding than prior versions, and 0xA3
is *not* a valid UTF8 character. Perhaps your data is really Latin1 or
some such?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sue Walker-Thornton 2006-07-17 16:52:32 Newbie help please....
Previous Message Tony Caduto 2006-07-17 15:14:40 Re: Simple webuser setup