| 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 10:15:11 |
| Message-ID: | 200202201015.g1KAFBFP024613@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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hervé Piedvache | 2002-02-20 10:20:36 | Re: Trouble with pg_dumpall import with 7.2 |
| Previous Message | Zeugswetter Andreas SB SD | 2002-02-20 08:34:29 | Re: SET NULL / SET NOT NULL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2002-02-20 14:12:18 | Re: UTF-8 data migration problem in Postgresql 7.2 |
| Previous Message | Jean-Michel POURE | 2002-02-20 07:35:29 | Re: UTF-8 data migration problem in Postgresql 7.2 |