From: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
To: Andrzej Angowski <andrzej.angowski@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: LATIN2 encoding and Polish_Poland locale
Date: Mon, 01 Mar 2010 14:49:21 +0100
Message-ID: <20100301134921.175810@gmx.net> (raw)
In-Reply-To: <edcfeeaa1002281344r4dcb7929ne49af06908a291a2@mail.gmail.com>
References: <edcfeeaa1002281344r4dcb7929ne49af06908a291a2@mail.gmail.com>
Hello Andrzej,
try this:
Identify the code page Windows is using for LATIN2 with the PostgreSQL tool pg_controldata (8.2 server's version). Look for the number following the dot in LC_COLLATE / LC_TYPE. For LATIN1 it's 28591.
Try creating the database for 8.4 with the PostgreSQL tool createdb (v8.4.x) (example for LATIN1 and German locale, locale = LC_COLLATE / LC_TYPE in 8.2):
createdb -U postgres -h <Host> -p <Port> --owner=name_of_owner --locale=German_Germany.28591 --encoding=LATIN1 --template=template0 database_name
Good luck,
Peter
-------- Original-Nachricht --------
> Datum: Sun, 28 Feb 2010 22:44:49 +0100
> Von: Andrzej Angowski <andrzej.angowski@gmail.com>
> An: pgsql-admin@postgresql.org
> Betreff: [ADMIN] LATIN2 encoding and Polish_Poland locale
> 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
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
Sicherer, schneller und einfacher. Die aktuellen Internet-Browser -
jetzt kostenlos herunterladen! http://portal.gmx.net/de/go/chbrowser
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: Jan-Peter.Seifert@gmx.de, andrzej.angowski@gmail.com
Subject: Re: LATIN2 encoding and Polish_Poland locale
In-Reply-To: <20100301134921.175810@gmx.net>
* 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