Re: UTF-8 data migration problem in Postgresql 7.2

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 14:40:51
Message-ID: 200202201440.g1KEepFP026305@www1.translationforge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-odbc

Dear Tatsuo,

Thank you for this answer.

> Why don't you edit the output from pg_dump? It's just a text file.
I edited the output in Yudit. Nothing seems to be wrong.

> > Why did 7.1.3 allow the input of such data?
> It's just becuase no data validation checking was there before 7.2.
Data was entered by a Japanese translator using IE5.5, japanese fonts, Win2K,
Apache and Php with UTF-8 extensions. How can it be wrong? It displays well
under IE5.5. Are you sure it is not a PostgreSQL 7.1.3 pg_dump related bug?
Other users have the same problem when migrating to 7.2.

Furthermore, do you think I can migrate data using ODBC adodb calls?

Thank you for your help,
Jean-Michel POURE

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-02-20 14:53:29 Re: SET NULL / SET NOT NULL
Previous Message Tatsuo Ishii 2002-02-20 14:12:18 Re: UTF-8 data migration problem in Postgresql 7.2

Browse pgsql-odbc by date

  From Date Subject
Next Message Tom Lane 2002-02-20 15:13:00 Re: [ODBC] UTF-8 data migration problem in Postgresql 7.2
Previous Message Tatsuo Ishii 2002-02-20 14:12:18 Re: UTF-8 data migration problem in Postgresql 7.2