From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Re: cp1250 problem
Date: Wed, 16 Feb 2011 11:11:44 +0200
Message-ID: <201102161111.44993.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <4D5AF76A.10800@gmx.de>
References: <AANLkTikAyxd5EcnuGd_jhhEENah-w8cdnw7sKZZMCUed@mail.gmail.com>
<201102151326.58744.achill@matrix.gatewaynet.com>
<4D5AF76A.10800@gmx.de>
Στις Wednesday 16 February 2011 00:00:10 ο/η Jan-Peter Seifert έγραψε:
> Hello,
>
> Am 15.02.2011 12:26, schrieb Achilleas Mantzios:
> > Στις 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).
>
> 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.
>
> > The locale for your whole cluster is defined in postgresql.conf.
>
> Not really - LC_COLLATE and LC_CTYPE are set during initialization of
> the cluster by initdb. You can verify the settings with pg_controldata:
>
That's true. Thanx.
> http://www.postgresql.org/docs/8.2/interactive/app-pgcontroldata.html
>
> 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.
>
> Peter
>
>
--
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: <201102161111.44993.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