Re: problem: Postgresql and Unicode

From: "Nathalie Boulos" <nathalieboulos(at)hotmail(dot)com>
To: arturp(at)plukwa(dot)net
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: problem: Postgresql and Unicode
Date: 2003-02-22 08:51:31
Message-ID: F136nOpj53XaDFuXCpU0000e3c1@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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, arturp(at)plukwa(dot)net
>
>---------------------------(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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Björn Metzdorf 2003-02-22 10:08:37 Re: problem: Postgresql and Unicode
Previous Message Tom Lane 2003-02-22 02:41:12 Re: Vacuum Question