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

=CE=A3=CF=84=CE=B9=CF=82 Wednesday 16 February 2011 00:00:10 =CE=BF/=CE=B7 =
Jan-Peter Seifert =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hello,
>=20
> Am 15.02.2011 12:26, schrieb Achilleas Mantzios:
> > =CE=A3=CF=84=CE=B9=CF=82 Tuesday 15 February 2011 12:44:31 =CE=BF/=CE=
=B7 Lukasz Brodziak =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> >> 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).
>=20
> There are no code pages in Ubuntu. The nearest what you can get seems to
> be encoding LATIN2 ( and a compatible locale ). These charsets are NOT
> identical though.
>=20
> > The locale for your whole cluster is defined in postgresql.conf.
>=20
> Not really - LC_COLLATE and LC_CTYPE are set during initialization of
> the cluster by initdb. You can verify the settings with pg_controldata:
>=20

That's true. Thanx.

> http://www.postgresql.org/docs/8.2/interactive/app-pgcontroldata.html
>=20
> As of PostgreSQL v8.4 you can specify these two locale settings
> different from the server's settings (for each database).
> If you plan to upgrade your PostgreSQL major server version beware of
> the removal of some implicit data type casts among other changes as of 8.=
3.
>=20
> Peter
>=20
>=20


=2D-=20
Achilleas Mantzios