Re: [ADMIN] Cannot create UTF8 database

2009-07-21 Thread raghu ram
On Tue, Jul 21, 2009 at 11:50 AM, Ibrahim Shaame wrote: > Thanks. It worked. > Ibrahim > > On Mon, Jul 20, 2009 at 11:58 AM, J. Carlos Muro 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.

Re: [ADMIN] Cannot create UTF8 database

2009-07-20 Thread Ibrahim Shaame
Thanks. It worked. Ibrahim On Mon, Jul 20, 2009 at 11:58 AM, J. Carlos Muro 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 > LAN

[ADMIN] Cannot create UTF8 database

2009-07-20 Thread Ibrahim Shaame
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 Li