DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=VqmNS6A3jv157yWxnBOZJeh1r6N58lGAZSRFN+XE2DZfBKacY+DmeobJXwIbJPeney
	mv7LqkzHGQsdsOyX88Nr/YpLF52Xt0giaqdLqrowSw1eJ7bfFbgwvzmMl30nGsxIZKF+
	7rnPq7fgLEnITTCGQH7eaoyRfdgzUJ6UJB2AY=
MIME-Version: 1.0
Date: Sun, 28 Feb 2010 22:44:49 +0100
Message-ID: <edcfeeaa1002281344r4dcb7929ne49af06908a291a2@mail.gmail.com>
Subject: LATIN2 encoding and Polish_Poland locale
From: Andrzej Angowski <andrzej.angowski@gmail.com>
To: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1

All,

I am running PostgreSQL database on Windows XP with SP3 machine.
Recently I have tried to upgrade from 8.2.15 to 8.4.2 but I encounter
the following issue: one of my databases is LATIN2 encoded
(ISO-8859-2). It works fine on 8.2.15 (LATIN2 encoding and
Polish_Poland locale - I have Polish characters and sorting works
fine), but on 8.4.2 default encoding for Polish_Poland is UTF-8. When
I try to set up LATIN2 encoding with Polish_Poland locale I get the
following error:

>createdb -E LATIN2 -l Polish_Poland test
createdb: database creation failed: ERROR:  encoding LATIN2 does not
match locale Polish_Poland
DETAIL:  The chosen LC_CTYPE setting requires encoding WIN1250.

In 8.4 manual -> Section 22.2 Character Set Support one can read:
An important restriction, however, is that each database's character
set must be compatible with the database's LC_CTYPE and LC_COLLATE
locale settings. For C or POSIX locale, any character set is allowed,
but for other locales there is only one character set that will work
correctly. (On Windows, however, UTF-8 encoding can be used with any
locale.)

So I manage to establish a DB with LATIN2 encoding with C locale:
>createdb -E LATIN2 -l C -T template0 test

I have Polish characters but sorting is not correct.

How can I set up Polish_Poland locale with LATIN2 encoding in PostgreSQL 8.4.2?


Thanks,
-- 
Andrzej Angowski