Re: [HACKERS] UTF-8 data migration problem in Postgresql 7.2 - Mailing list pgsql-odbc

From Jean-Michel POURE
Subject Re: [HACKERS] UTF-8 data migration problem in Postgresql 7.2
Date
Msg-id 200202201015.g1KAFBFP024613@www1.translationforge
Whole thread Raw
In response to Re: [HACKERS] UTF-8 data migration problem in Postgresql 7.2  (Jean-Michel POURE <jm.poure@freesurf.fr>)
Responses Re: [HACKERS] UTF-8 data migration problem in Postgresql 7.2
Re: [HACKERS] UTF-8 data migration problem in Postgresql 7.2
List 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 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

pgsql-odbc by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: [HACKERS] UTF-8 data migration problem in Postgresql 7.2
Next
From: Jean-Michel POURE
Date:
Subject: Re: [HACKERS] UTF-8 data migration problem in Postgresql 7.2