Re: encoding problem when creating a database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "A B" <gentosaker(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: encoding problem when creating a database
Date: 2008-07-02 16:48:06
Message-ID: 12974.1215017286@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"A B" <gentosaker(at)gmail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2008-07-02 17:00:51 Re: encoding problem when creating a database
Previous Message Phillip Sitbon 2008-07-02 16:44:21 Concurrent COPY commands