From: frederic massot <frederic@juliana-multimedia.com>
To: pgsql-php@postgresql.org
Subject: Re: Pb with the French accentuated characters
Date: Tue, 30 Apr 2002 18:56:56 +0200
Message-ID: <3CCECCD8.A11B8F8C@juliana-multimedia.com> (raw)
References: <3CCE936B.245D870C@juliana-multimedia.com>
<200204301522.44037.jm.poure@freesurf.fr>
Jean-Michel POURE wrote:
>
>
> So I presume your database is Unicode.
>
> > Error messages with psql :
> > juliana=> insert into essai values ('était');
> > ERROR: Invalid UNICODE character sequence found (0xe97461)
> > juliana=> insert into essai values ('ètait');
> > ERROR: Invalid UNICODE character sequence found (0xe87461)
> > juliana=> insert into essai values ('àtait');
> > ERROR: Invalid UNICODE character sequence found (0xe07461)
>
> Enter:
> SET CLIENT_ENCODING = 'Latin9'
>
> This will recode backend<->client stream from Unicode to Latin + Euro
> encoding. If you don't need Euro support, you could also recode to Latin1.
I have just tested your solutions:
juliana=> select * from essai;
un
----
(0 rows)
juliana=> insert into essai values ('était');
ERROR: Invalid UNICODE character sequence found (0xe97461)
juliana=> SET CLIENT_ENCODING = 'latin9';
SET VARIABLE
juliana=> insert into essai values ('était');
INSERT 225971 1
juliana=> select * from essai;
un
------
tait
(1 row)
juliana=> SET CLIENT_ENCODING = 'latin1';
SET VARIABLE
juliana=> insert into essai values ('était');
INSERT 225972 1
juliana=> select * from essai;
un
------
tait
tait
(2 rows)
There is always a problem with the accents, Arghh !!!
Regards.
--
==============================================
| FREDERIC MASSOT |
| http://www.juliana-multimedia.com |
| mailto:frederic@juliana-multimedia.com |
===========================Debian=GNU/Linux===
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: frederic@juliana-multimedia.com
Subject: Re: Pb with the French accentuated characters
In-Reply-To: <3CCECCD8.A11B8F8C@juliana-multimedia.com>
References: <3CCE936B.245D870C@juliana-multimedia.com> <200204301522.44037.jm.poure@freesurf.fr> <3CCECCD8.A11B8F8C@juliana-multimedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox