From: | "Nathalie Boulos" <nathalieboulos(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | encoding problem |
Date: | 2003-02-19 12:00:59 |
Message-ID: | F1043HP7YDqgdsDCHro00039a25@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Yudha Setiawan | 2003-02-19 12:59:22 | How to avoid the Mutating Triggers ?? |
Previous Message | Donald Fraser | 2003-02-19 11:02:44 | Re: uppercase = lowercase |