| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: server , client encoding issue |
| Date: | 2005-10-18 12:34:09 |
| Message-ID: | 4354EBC1.4040102@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jfo123 | 2005-10-18 12:52:58 | Wrong charset? |
| Previous Message | Richard Huxton | 2005-10-18 12:32:24 | Re: Serializable isolation level |