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

Re: encoding problem when creating a database

From: "A B" <gentosaker(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: encoding problem when creating a database
Date: 2008-07-02 14:55:35
Message-ID: dbbf25900807020755vfe78528x356613aacb7a770e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)gmail(dot)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?
>

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2008-07-02 14:57:55
Subject: Re: Calculating repeating events - functionality lost with the demise of tinterval ?
Previous:From: A BDate: 2008-07-02 14:11:35
Subject: Re: encoding problem when creating a database

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