Re: importing from 8.0.3 unicode problem

From: tomas(at)tuxteam(dot)de (Tomas Zerolo)
To: Theodore Petrosky <tedpet5(at)yahoo(dot)com>
Cc: pgsql -bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: importing from 8.0.3 unicode problem
Date: 2005-10-31 04:39:56
Message-ID: 20051031043956.GA21342@www.trapp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sun, Oct 30, 2005 at 12:23:00PM -0800, Theodore Petrosky wrote:
> I don't know if this is a bug or my not understanding
> something.
[...]
> I get an error:
> ERROR: invalid UNICODE byte sequence detected near
> byte 0x8e
> CONTEXT: COPY ioinfo, line 177, column publication:
> "Elle D?cor"
> ERROR: invalid UNICODE byte sequence detected near
> byte 0xa5

[...]

Everything indicates that you have an iso-8859-1 `e with acute' there.
So whatever went wrong, it was at (or before) dump time.

Regards
-- tomás

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ivan 2005-10-31 09:24:09 Re: pg_dump bud with functions
Previous Message Roddi Walker 2005-10-31 02:34:00 BUG #2010: COPY command does not recognise UTF-8 text files with leading BOM