Horton
Menu

Re: UTF-8 data migration problem in Postgresql 7.2

Jean-Michel POURE <jm.poure@freesurf.fr>

View thread
From: Jean-Michel POURE <jm.poure@freesurf.fr>
To: Tatsuo Ishii <t-ishii@sra.co.jp>
Cc: pgsql-hackers@postgresql.org, pgsql-odbc@postgresql.org, Inoue@tpf.co.jp
Date: 2002-02-20T07:35:29Z
Lists: pgsql-hackers 
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