Re: encoding problem when creating a database - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: encoding problem when creating a database
Date
Msg-id 20080702095824.I41991@megazone.bigpanda.com
Whole thread Raw
In response to Re: encoding problem when creating a database  ("A B" <gentosaker@gmail.com>)
List pgsql-novice
On Wed, 2 Jul 2008, A B wrote:

> alright, now I have created a new db-cluster with initdb -E UTF8
> --locale=C and the encoding problem still remains when trying to
> access with PHP.
>
> Error ERROR: invalid byte sequence for encoding "UTF8": 0xe56e69 HINT: This
> error can also happen if the byte sequence does not match the encoding
> expected by the server, which is controlled by "client_encoding".

That sequence isn't valid UTF8. What encoding is the PHP script trying to
send data in? If it's something other than UTF8 (for example ISO8859-1),
you need to set client_encoding to the correct encoding.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: encoding problem when creating a database
Next
From: Tom Lane
Date:
Subject: Re: Calculating repeating events - functionality lost with the demise of tinterval ?