Re: [ODBC] UTF-8 data migration problem in Postgresql 7.2

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: jm.poure@freesurf.fr
Cc: Tatsuo Ishii <t-ishii@sra.co.jp>, pgsql-hackers@postgresql.org, pgsql-odbc@postgresql.org, Inoue@tpf.co.jp
Date: 2002-02-20T17:04:29Z
Lists: pgsql-hackers
Jean-Michel POURE <jm.poure@freesurf.fr> writes:
> You are right, Yudit shows an invalid UTF-8 character.

> For example, record OID 20643 has invalid =E3=82 character. But, when 
> querying the PostgreSQL 7.1.3 database, I can see the missing character which
> displays well in Apache/PHP.

Does your Apache/PHP environment set any particular client encoding?

I am wondering if Apache is seeing a different translation of the
database contents than what pg_dump got.

BTW, it seems entirely likely that Windows apps might display something
for UTF-8 sequences that are invalid according to the published specs.
It'd be just like Microsoft to "extend" the standard...

			regards, tom lane