server , client encoding issue
hi all
i am facing a problem and here it is:
i install the following (postgres) rpms as root
postgresql-libs-8.0.0-1PGDG.i686.rpm
postgresql-8.0.0-1PGDG.i686.rpm
and
postgresql-server-8.0.0-1PGDG.i686.rpm
now i try to create a database
/usr/bin/createdb temp
when i connect to it
it shows: server_encoding : LATIN9
and client_encoding: LATIN9
from where did it get these values
i want them to be UNICODE.
please help
( i know there is a workaround to this problem -
/usr/bin/createdb -E UNICODE temp )
but this is happening at a particular machine . On other machines it is UNICODE.
thanks
regards
surabhi
surabhi.ahuja wrote:
when i connect to it
it shows: server_encoding : LATIN9
and client_encoding: LATIN9from where did it get these values
From your environment - the machine is presumably defaulting to some
locale that uses LATIN9 for it's character-set.
i want them to be UNICODE.
please help
( i know there is a workaround to this problem -
/usr/bin/createdb -E UNICODE temp )but this is happening at a particular machine . On other machines it is UNICODE.
It's not really a workaround - I always specify encoding for the
databases I create (precisely to avoid this sort of problem).
--
Richard Huxton
Archonet Ltd