X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8631B475458 for ; Wed, 19 Feb 2003 07:00:58 -0500 (EST) Received: from hotmail.com (f104.pav1.hotmail.com [64.4.31.104]) by postgresql.org (Postfix) with ESMTP id 0B782475425 for ; Wed, 19 Feb 2003 07:00:56 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 19 Feb 2003 04:00:59 -0800 Received: from 193.227.168.171 by pv1fd.pav1.hotmail.msn.com with HTTP; Wed, 19 Feb 2003 12:00:59 GMT X-Originating-IP: [193.227.168.171] From: "Nathalie Boulos" To: pgsql-admin@postgresql.org Subject: encoding problem Date: Wed, 19 Feb 2003 14:00:59 +0200 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 19 Feb 2003 12:00:59.0466 (UTC) FILETIME=[910FAAA0:01C2D80E] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/306 X-Sequence-Number: 7504 Hello, I am testing Win2k clients in reading/writing arabic in Postgres DB via web (apache with scripts written in PHP). I have 2 PostgreSQL DB created with -E unicode: One on RH linux 7.1 (postgresql-7.0.3-8) (CASE 1) The other on RH linux 8.0 (postgres-7.2.2-1) (CASE 2) In case 1, a win2k client writes to a postgres7.0 DB and the arabic letters can clearly be read in "psql" and on the web. In case 2, a win2k client writes to the 7.2 postgres, the arabic input is in psql: test=# select * from ttest; nom_fr | nom_ar -----------+----------------------- nathalie | //invisible when no charset defined in web page nathalie | nathalie1 | latino | dfww | بيب //has this format when charset=UTF8 dfww | بيب (6 rows) Is that related to the automatic conversion in postgres7.2? When i get the &#xxxx; format, each letter is consuming 7 caracters in the database! I cannot understand the difference btw the 2 versions of postgres. I would greatly appreciate any help. and what should i do to see the arabic letters in the version 7.2? Thank you in advance. Regards Nathalie _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail