Postgres Pro
Downloads
Home   >   mailing lists

server , client encoding issue - Mailing list pgsql-general

From surabhi.ahuja
Subject server , client encoding issue
Date
Msg-id 967CFC4343BF2A4DAFACD026D33DC85118EC78@jal.iiitb.ac.in
Whole thread Raw
Responses Re: server , client encoding issue  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view
 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

pgsql-general by date:

Previous
From: John Dean
Date:
Subject: Re: ANN: Rekall V2.4.0
Next
From:
Date:
Subject: Serializable isolation level