Home > mailing lists

server , client encoding issue - Mailing list pgsql-general

From	surabhi.ahuja
Subject	server , client encoding issue
Date	October 20, 2005 02:29:45
Msg-id	967CFC4343BF2A4DAFACD026D33DC85118EC79@jal.iiitb.ac.in Whole thread Raw
List	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

From: "Craig"
Date: 20 October 2005, 01:32:38
Subject: How Do I install the Admin Module (pgAdmin III)

From: "Dean Gibson (DB Administrator)"
Date: 20 October 2005, 02:50:57
Subject: PSQL suggested enhancement