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

Re: Cannot create UTF8 database

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: Ibrahim Shaame <ishaame(at)gmail(dot)com>
Cc: "J(dot) Carlos Muro" <murojc(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Cannot create UTF8 database
Date: 2009-07-21 08:23:20
Message-ID: d331f2ee0907210123p5984bc2aha80c558ad4e2fbb2@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Jul 21, 2009 at 11:50 AM, Ibrahim Shaame <ishaame(at)gmail(dot)com> wrote:

> Thanks. It worked.
> Ibrahim
>
> On Mon, Jul 20, 2009 at 11:58 AM, J. Carlos Muro <murojc(at)gmail(dot)com> wrote:
>
>> I think you need to setup locale of the user who inits/runs the cluster
>> (generally "postgres') to unicode in order to init a unicode cluster.
>> Try to set your locale environment variables to for example
>> LANG=xx_XX.UTF-8 (for example "en_US.UTF-8" or whichever on your
>> convenience), then try to create your cluster.
>>
>> 2009/7/20 Ibrahim Shaame <ishaame(at)gmail(dot)com>
>>
>> I Have just installed version Postgresql-8.4.0 and when I run initdb -E
>>> utf8 it tells me that the current local (LATIN1 or rather LC_CTYPE) cannot
>>> accept the utf8. Then when I run initdb with the default local, I cannot
>>> create a utf8 database any way (be it in psql or pgadmin3).
>>>
>>> Any hint?
>>> I use Linux slamd64 12.2 (A Slackware dialect)
>>
>>
you can able to create cluster using below command also

initdb -D /opt/PostgresPlus/8.3R2AS/data4 -E UTF8 --locale=C

Regards,
Raghu Ram

>
>>>
>>> Thanks
>>> Ibrahim Shaame
>>>
>>
>>
>

In response to

pgsql-admin by date

Next:From: Andreas WenkDate: 2009-07-21 10:18:44
Subject: Re: implement ldap authentication in PostgreSQL
Previous:From: Ibrahim ShaameDate: 2009-07-21 06:20:38
Subject: Re: Cannot create UTF8 database

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