UTF-8 data migration problem in Postgresql 7.2

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: pgsql-hackers(at)postgresql(dot)org
Cc: pgsql-odbc(at)postgresql(dot)org, Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Subject: UTF-8 data migration problem in Postgresql 7.2
Date: 2002-02-19 15:38:35
Message-ID: 200202191538.g1JFcZFP018267@www1.translationforge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-odbc

Dear all,

I tried to migrate a UTF-8 database with Japanese content from Postgresql
7.1.3 to Postgresql 7.2 unsucessfully.

I made a pg_dump of the 7.1.3 database and tried to upload it in 7.2.
Error message was "Invalid Unicode character sequence found".

I tried to upload data in a fresh PostgreSQL 7.1.3 database and everything
worked OK. The problem can be reproduced on PostgreSQL 7.2.

Do not hesitate to ask me for a pg_dump of the involved tables. I cannot
submit them on the list for privacy reasons. Thanks for your help.

Cheers,
Jean-Michel POURE

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-02-19 15:49:02 elog() cleanup
Previous Message Marc G. Fournier 2002-02-19 15:20:12 Re: www.postgresql.org 404 error...

Browse pgsql-odbc by date

  From Date Subject
Next Message Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= 2002-02-19 16:03:20 Re: UTF-8 data migration problem in Postgresql 7.2
Previous Message Dave Page 2002-02-19 12:01:57 Re: Hebrew support