Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group