Pb with the French accentuated characters

From: frederic massot <frederic(at)juliana-multimedia(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: Pb with the French accentuated characters
Date: 2002-04-30 12:51:55
Message-ID: 3CCE936B.245D870C@juliana-multimedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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(at)juliana-multimedia(dot)com |
===========================Debian=GNU/Linux===

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Jean-Michel POURE 2002-04-30 13:22:44 Re: Pb with the French accentuated characters
Previous Message Surojit Niyogi 2002-04-29 15:58:39 Re: Check Boxes