Re: [ADMIN] problem: Postgresql and Unicode

2003-02-22 Thread Björn Metzdorf
> But now I'm facing another problem: > How do I convert existing data in an SQL_ASCII database to unicode? > > Has anyone tried this before? Yes, that is no problem. Have a look at http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=multibyte.ht ml#AEN21920 short: dump sql_ascii, cre

Re: [ADMIN] problem: Postgresql and Unicode

2003-02-22 Thread Nathalie Boulos
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

Re: [ADMIN] problem: Postgresql and Unicode

2003-02-21 Thread Artur Pietruk
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()

Re: [ADMIN] problem: Postgresql and Unicode

2003-02-21 Thread Antti Haapala
On Fri, 21 Feb 2003, Nathalie Boulos wrote: > 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 (0xe4) > > the client is a IE browser on