Обсуждение: Cannot create UTF8 database

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@gmail.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)

Thanks
Ibrahim Shaame

Thanks. It worked.
Ibrahim

On Mon, Jul 20, 2009 at 11:58 AM, J. Carlos Muro <murojc@gmail.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@gmail.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)

Thanks
Ibrahim Shaame