Hi Arthur ,
Thank you very much for your reply.
It was indeed a PHP problem. I just set the default_charset variable in php.ini to utf-8 and it worked.
But now I'm facing another problem: How do I convert existing data in an SQL_ASCII database to unicode?
here's my problem:
I have a SQL_ASCII postgres db containing data.
I've updated the pg_database table and set the encoding to UNICODE for this database.
I've changed the php.ini charset variable to utf-8.
When i add new rows to the table, I can read and write successfully in unicode.
But if i want to see the old existing data, i have problems visualizing the special characters (like french lettres with accents).
So i guess i have to convert the old data.
Has anyone tried this before?
Thanks for your help.
Regards Nat
On Fri, Feb 21, 2003 at 11:01:31AM +0200, Nathalie Boulos wrote: > Hi everyone,
Hi!
> 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'"); )
Could you show us how does your PHP script looks like? Setting client encoding on the postgres side, can be not enough. Did you set encoding of your PHP page to UTF, using content-type meta tag? Make sure, that data you want to insert, is in fact unicode. I'm just wild-guessing, I have never created unicode DB in postgres, but I was fighting with enocding issues here and there.
Best regards, -- --- Artur Pietruk, [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
