From: Nathalie Boulos <nathalieboulos@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: encoding problem
Date: Wed, 19 Feb 2003 14:00:59 +0200
Message-ID: <F1043HP7YDqgdsDCHro00039a25@hotmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: nathalieboulos@hotmail.com
Subject: Re: encoding problem
In-Reply-To: <F1043HP7YDqgdsDCHro00039a25@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox