Re: [GENERAL] problems with encoding and accent letters

2010-07-03 Thread aaaawwww
On Jul 2, 12:39 am, pie...@hogranch.com (John R Pierce) wrote: > On 07/01/10 2:27 PM, wrote: > > > Sorry I forgot to say I am running an Italian php website with a > > postgresql DB. Users can write messages eachothers. > > This is my code: > > $connessione_db = pg_connect("dbname=x us

Re: [GENERAL] problems with encoding and accent letters

2010-07-01 Thread John R Pierce
On 07/01/10 2:27 PM, wrote: Sorry I forgot to say I am running an Italian php website with a postgresql DB. Users can write messages eachothers. This is my code: $connessione_db = pg_connect("dbname=x user=y password=zz"); $sql_insert_messaggio="insert into messaggio (text) v

Re: [GENERAL] problems with encoding and accent letters

2010-07-01 Thread aaaawwww
Sorry I forgot to say I am running an Italian php website with a postgresql DB. Users can write messages eachothers. This is my code: $connessione_db = pg_connect("dbname=x user=y password=zz"); $sql_insert_messaggio="insert into messaggio (text) values ('àèì');"; pg_exec ($connessione_

Re: [GENERAL] problems with encoding and accent letters

2010-07-01 Thread Peter Geoghegan
On 1 July 2010 15:43, wrote: > My DB is UTF8 and I cannot change it. > When I try to insert accent letters like è ò ... I get > Query failed: ERROR: invalid byte sequence for encoding "UTF8": > 0xe82729 HINT: This error can also happen if the byte sequence does > not match the encoding ex

Re: [GENERAL] problems with encoding and accent letters

2010-07-01 Thread Peter Geoghegan
On 1 July 2010 15:43, wrote: > My DB is UTF8 and I cannot change it. > When I try to insert accent letters like è ò ... I get > Query failed: ERROR: invalid byte sequence for encoding "UTF8": > 0xe82729 HINT: This error can also happen if the byte sequence does > not match the encoding ex

[GENERAL] problems with encoding and accent letters

2010-07-01 Thread aaaawwww
My DB is UTF8 and I cannot change it. When I try to insert accent letters like è ò ... I get Query failed: ERROR: invalid byte sequence for encoding "UTF8": 0xe82729 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "cli