Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id C2D31475C4E for ; Tue, 30 Apr 2002 09:10:33 -0400 (EDT) Received: from eole.juliana-multimedia.com (eole.juliana-multimedia.com [212.155.110.2]) by postgresql.org (Postfix) with ESMTP id 9B420475F9F for ; Tue, 30 Apr 2002 08:51:53 -0400 (EDT) Received: from juliana-multimedia.com (unknown [212.155.110.22]) by eole.juliana-multimedia.com (Postfix) with ESMTP id CA6DB174BF for ; Tue, 30 Apr 2002 14:51:55 +0200 (CEST) Message-ID: <3CCE936B.245D870C@juliana-multimedia.com> Date: Tue, 30 Apr 2002 14:51:55 +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: Pb with the French accentuated characters Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200204/102 X-Sequence-Number: 1126 Hello, Since the update of a PC of test (Debian GNU/Linux Woody, Apache 1.3.23-1, Php4 4.1.2, Postgresql 7.2.1), the Web sites functioning on this PC produce errors during the insertion of French accentuated characters ("é", "č", "ŕ", etc...) in the databases. An error message with PHP : PostgreSQL query failed: ERROR: Invalid UNICODE character sequence found (0xe97373) 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) With version 7.1.3 of Postgresql not did not have any errors. All the databases are encoding in UNICODE. Postgresql is compiled with the option "--enable-unicode-conversion". I know that version 7.2.1 of Postgresql checks the data before inserting them. But I do not understand why conversion does not function. Do you have an idea ? Thank you. -- ============================================== | FREDERIC MASSOT | | http://www.juliana-multimedia.com | | mailto:frederic@juliana-multimedia.com | ===========================Debian=GNU/Linux===