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