Re: UTF-8 data migration problem in Postgresql 7.2

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

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-20T10:15:11Z
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 all,

Can anyone help me understand where the problem stems from.

1) Is this a data perversion problem (=wrong UTF-8 sequences entered)? Then, 
how can I fix it? Why did 7.1.3 allow the input of such data?

2) The data was created with pg_dump. It loads without problem in 7.1.3. But 
not  in 7.2. Why?

3) Ultimately, please tell me if I can use ADODB odbc calls to migrate UTF-8 
data using VB. Are there special settings required? Should I wait for a fix 
in 7.2 or should I go for VB right now?

I am stuck and cannot work anymore (my new code is on 7.2, the old data is on 
7.1.3). Thank you for your help,

Cheers,
Jean-Michel POURE