Re: UTF-8 data migration problem in Postgresql 7.2

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org, Inoue(at)tpf(dot)co(dot)jp
Subject: Re: UTF-8 data migration problem in Postgresql 7.2
Date: 2002-02-20 07:35:29
Message-ID: 200202200735.g1K7ZUFP023439@www1.translationforge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-odbc

Le Mercredi 20 Février 2002 01:50, Tatsuo Ishii a écrit :
> The error messages shows your data contains an invalid UTF-8 character
> sequence. The first byte (e8) expects the UTF-8 sequence consists of 3
> bytes, each of 8th bit on. However the third byte is 0x27, apparently
> it does not satisfy the requirement. Check your data.

Dear Tatsuo,

This data was created using pg_dump in PostgreSQL 7.1.3. The data load well
in PostgreSQL 7.1.3, but not into PostgreSQL 7.2.

Is this a bug or is the data faulty? How can I verify UTF-8 data already
stored into PostgreSQL 7.1.3?

Best regards,
Jean-Michel POURE

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB SD 2002-02-20 08:34:29 Re: SET NULL / SET NOT NULL
Previous Message Christopher Kings-Lynne 2002-02-20 06:13:27 Re: SET NULL / SET NOT NULL

Browse pgsql-odbc by date

  From Date Subject
Next Message Jean-Michel POURE 2002-02-20 10:15:11 Re: UTF-8 data migration problem in Postgresql 7.2
Previous Message Hiroshi Inoue 2002-02-20 04:52:25 Re: Are multiple selects of the same field allowed