Re: encoding problem
От | John DeSoi |
---|---|
Тема | Re: encoding problem |
Дата | |
Msg-id | CFC2F354-28E2-40A2-B2A3-9853D2E1A8AC@pgedit.com обсуждение исходный текст |
Ответ на | Re: encoding problem ("Zouari Fourat" <fourat@gmail.com>) |
Список | 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
В списке pgsql-novice по дате отправления: