From: | John DeSoi <desoi(at)pgedit(dot)com> |
---|---|
To: | Zouari Fourat <fourat(at)gmail(dot)com> |
Cc: | nikolay(at)samokhvalov(dot)com, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: encoding problem |
Date: | 2006-03-05 15:08:34 |
Message-ID: | CFC2F354-28E2-40A2-B2A3-9853D2E1A8AC@pgedit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Mar 5, 2006, at 6:07 AM, Zouari Fourat wrote:
> i get this error (using adodb from php) :
>
> ---------------------------------------------------------------
> postgres7 error: [-1: ERREUR: Séquence d'octets invalide pour le
> codage «UNICODE» : 0xe96869] in EXECUTE("INSERT INTO hotqueues
> (tcontent) VALUES('Méhiya c mon nom')")
> ---------------------------------------------------------------
>
> when copy-pasting that INSERT query into phppgadmin or psql console,
> the query is executed with no error.
The problem is most likely the wrong client_encoding setting in php.
In php, execute the the SQL query "SHOW client_encoding" and see what
you get. If you are not using multi-byte strings in php, my guess is
you want "SET client_encoding TO 'LATIN1'" or something similar to
fix it.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Nagita Karunaratne | 2006-03-05 21:24:04 | exporting data from one DB to another asynchronously |
Previous Message | Zouari Fourat | 2006-03-05 11:07:44 | Re: encoding problem |