Re: encoding problem when creating a database

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".

I'm really lost on what to do with this.
Any ideas anyone?

2008/7/2 A B <gentosaker@gmail.com>:
>> You have created the db-cluster with sv_SE.iso88591. Because of this,
>> you can't now create a db with an incompatible locale.
>
> Oh, so i need to run something like
> initdb -E UTF8  --pgdata XXX
> to create a new db-cluster?
> What about the --locale option? Something I need to do with that?
>
> What should let XXX be? I have all the stuff in /var/lib/pgsql/ and
> I'd like to put it all there.
>
> Do I have to do something after createing a new db-cluster or can I
> start createing databases as ususal?
>