Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 9AE8F4760FC for ; Tue, 30 Apr 2002 13:00:46 -0400 (EDT) Received: from eole.juliana-multimedia.com (eole.juliana-multimedia.com [212.155.110.2]) by postgresql.org (Postfix) with ESMTP id 2B0C6475A42 for ; Tue, 30 Apr 2002 12:56:55 -0400 (EDT) Received: from juliana-multimedia.com (unknown [212.155.110.22]) by eole.juliana-multimedia.com (Postfix) with ESMTP id 43D88174BF for ; Tue, 30 Apr 2002 18:57:00 +0200 (CEST) Message-ID: <3CCECCD8.A11B8F8C@juliana-multimedia.com> Date: Tue, 30 Apr 2002 18:56:56 +0200 From: frederic massot Organization: Juliana =?iso-8859-1?Q?Multim=E9dia?= X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.4.17 i686) X-Accept-Language: fr-FR, fr, en MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Re: Pb with the French accentuated characters References: <3CCE936B.245D870C@juliana-multimedia.com> <200204301522.44037.jm.poure@freesurf.fr> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200204/106 X-Sequence-Number: 1130 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===