problem: Postgresql and Unicode

From: "Nathalie Boulos" <nathalieboulos(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: problem: Postgresql and Unicode
Date: 2003-02-21 09:01:31
Message-ID: F136TWApLOjzbBmLGQ50000b8e8@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everyone,

I'm using postgresql-7.2.2-1 under RedHat linux 8.0.

I created a unicode DB and trying to insert arabic text through a php script
on the web. I'm getting the following error:
Warning: pg_exec() query failed: ERROR: Invalid UNICODE character sequence
found (0xe40000)

the client is a IE browser on a win2000 machine, with arabic support.
(I'm forcing client encoding to unicode before i insert data in the DB by
adding the following line in the PHP script:
pg_exec($db,"set client_encoding='unicode'"); )

Any ideas?

I'd greatly appreciate any help and thanks in advance

Regards
Nathalie

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Antti Haapala 2003-02-21 09:43:54 Re: problem: Postgresql and Unicode
Previous Message Oleg Samoylov 2003-02-21 08:55:24 Re: Logging for psql only