Re: server , client encoding issue

i checked the locale it is giving:

LANG=en_US.iso885915
LC_CTYPE="en_US.iso885915"
LC_NUMERIC=en_US
LC_TIME="en_US.iso885915"
LC_COLLATE="en_US.iso885915"
LC_MONETARY="en_US.iso885915"
LC_MESSAGES="en_US.iso885915"
LC_PAPER="en_US.iso885915"
LC_NAME="en_US.iso885915"
LC_ADDRESS="en_US.iso885915"
LC_TELEPHONE="en_US.iso885915"
LC_MEASUREMENT="en_US.iso885915"
LC_IDENTIFICATION="en_US.iso885915"
LC_ALL=

is it "lang" that is "LATIN9"

________________________________

From: Richard Huxton [mailto:dev(at)archonet(dot)com]
Sent: Tue 10/18/2005 6:04 PM
To: surabhi.ahuja
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] server , client encoding issue

***********************
Your mail has been scanned by InterScan VirusWall.
***********-***********

surabhi.ahuja wrote:
> when i connect to it
> it shows: server_encoding : LATIN9
> and client_encoding: LATIN9
>
> from 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