From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: Re: cp1250 problem
Date: Tue, 15 Feb 2011 13:26:58 +0200
User-Agent: KMail/1.9.7
References: <AANLkTikAyxd5EcnuGd_jhhEENah-w8cdnw7sKZZMCUed@mail.gmail.com>
In-Reply-To: <AANLkTikAyxd5EcnuGd_jhhEENah-w8cdnw7sKZZMCUed@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <201102151326.58744.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 Tuesday 15 February 2011 12:44:31 =CE=BF/=CE=B7 Lu=
kasz Brodziak =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hello,
>=20
> 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).
>=20

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=20
lists who has what.


> --=20
> =C5=81ukasz 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"
>=20


=2D-=20
Achilleas Mantzios