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

From Tom Lane
Subject Re: encoding problem when creating a database
Date
Msg-id 12974.1215017286@sss.pgh.pa.us
Whole thread Raw
In response to Re: encoding problem when creating a database  ("A B" <gentosaker@gmail.com>)
List pgsql-novice
"A B" <gentosaker@gmail.com> writes:
> 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".

What encoding is your PHP script actually working in?  It's apparently
not UTF8.

            regards, tom lane

pgsql-novice by date:

Previous
From: Phillip Sitbon
Date:
Subject: Concurrent COPY commands
Next
From: Stephan Szabo
Date:
Subject: Re: encoding problem when creating a database