From: Frank Finner <postgresql@finner.de>
To: Nicolas Cornu <nicolas.cornu@cyber-developpement.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Caracter é
Date: Sat, 6 Aug 2005 23:34:18 +0200
Message-ID: <20050806233418.407bfff9.postgresql@finner.de> (raw)
In-Reply-To: <42F52480.3090207@cyber-developpement.com>
References: <42F52480.3090207@cyber-developpement.com>
Hi,
what encoding do your webpages have, and what encoding does your database have? If both have the same encoding (eg both UTF8 or both Latin1), all should go well, otherwise you will have to adapt encodings before putting form data into the database (and vice versa), eg with utf_encode / utf_decode.
We had a similiar problem, since we encode both, webpages and database, as utf8, there is no longer such a problem. We use php 4.4.x, postgresql 8.0.3 and pear.
Regards, Frank.
On Sat, 06 Aug 2005 22:58:40 +0200 Nicolas Cornu <nicolas.cornu@cyber-developpement.com> thought long, then sat down and wrote:
>
> Hello,
>
> I compiled Postgresql 8 on my server and installed it
> I am trying to insert a string using php and PEAR::DB
>
> The string contain: é and this cause
> $db-query to fail with an Unkown error as error message.
>
> If i insert the data using pgAdminIII the string is inserted into the
> table.
>
> I don't think it is Postgres related, do i need to ask to PEAR::DB team ?
>
> Thanks in adavance,
>
> CN
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Frank Finner
Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606 Mail: frank.finner@invenius.de
Telefax: 0271 231 8608 Web: http://www.invenius.de
Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@finner.de, nicolas.cornu@cyber-developpement.com
Subject: Re: Caracter é
In-Reply-To: <20050806233418.407bfff9.postgresql@finner.de>
* 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