server , client encoding issue

From: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: server , client encoding issue
Date: 2005-10-18 11:18:37
Message-ID: 967CFC4343BF2A4DAFACD026D33DC85118EC78@jal.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Dean 2005-10-18 11:20:45 Re: ANN: Rekall V2.4.0
Previous Message Amit Sanon 2005-10-18 11:16:53 postgres service does not start after windows restart