Re: [ODBC] 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: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Tatsuo Ishii <t-ishii@sra.co.jp>, pgsql-hackers@postgresql.org, pgsql-odbc@postgresql.org, Inoue@tpf.co.jp
Date: 2002-02-20T17:13:03Z
Lists: pgsql-hackers
> 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. I recompiled PHP with UTF-8 internal encoding. So no transcoding is performed. > 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... It might be the case, I agree. Could it be a problem of surface (UCS-2 characters embedded in UTF-8)? PostgreSQL 7.3 should accept more UTF-8 characters anyway as I can display all Japanese characters. Many users may have the same problem. So why filter? Again, Ithe problem might also come from pg_dump. The database has French and Dutch content. There are also errors in the Dutch file... Is there a way to perform some testing? Cheers, Jean-Michel POURE