From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Re: cp1250 problem
Date: Tue, 15 Feb 2011 13:26:58 +0200
Message-ID: <201102151326.58744.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <AANLkTikAyxd5EcnuGd_jhhEENah-w8cdnw7sKZZMCUed@mail.gmail.com>
References: <AANLkTikAyxd5EcnuGd_jhhEENah-w8cdnw7sKZZMCUed@mail.gmail.com>
Στις Tuesday 15 February 2011 12:44:31 ο/η Lukasz Brodziak έγραψε:
> Hello,
>
> How can I set PostgreSQL locale and encoding to be pl_PL.cp1250 all I
> can do is pl_PL.UTF-8.
> I have PG 8.2.4 on Ubuntu 10.04 (polish version).
>
I had similar issues with the Greek ISO locale/encoding and the UTF one.
If i had known earlier i would have implemented UTF since day one.
UTF-8 support is pretty mature, so i dont see any reason for people to
hold back to ISO encodings (in year 2011!)
The locale for your whole cluster is defined in postgresql.conf.
(and i believe the value is inherited by the ENV variables at initdb time)
Now each database has its *own* encoding.
psql -l
lists who has what.
> --
> Łukasz Brodziak
> "What if everyting around You isn't quite as it seems,
> What if all the world You think You know is an inelaborate dream
> When You look at Your reflection is that all you want it to be
> What if You could look right through the cracks
> Would You find Yourself...... Find Yourself afraid to see"
>
--
Achilleas Mantzios
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com
Subject: Re: cp1250 problem
In-Reply-To: <201102151326.58744.achill@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox