Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group