pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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===



view thread (5+ messages)

Message-ID: <3CCECCD8.A11B8F8C@juliana-multimedia.com>
Permalink:  ../3CCECCD8.A11B8F8C@juliana-multimedia.com/
Also on:    postgresql.org/message-id/3CCECCD8.A11B8F8C@juliana-multimedia.com

 · 

reply

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