Re: Linux, Hungarian charset (Win1250) is supports the hungarian collation? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Linux, Hungarian charset (Win1250) is supports the hungarian collation?
Date
Msg-id 1300921934.15640.2.camel@vanquo.pezone.net
Whole thread Raw
In response to Linux, Hungarian charset (Win1250) is supports the hungarian collation?  (Durumdara <durumdara@gmail.com>)
List pgsql-general
On mån, 2011-03-21 at 11:22 +0100, Durumdara wrote:
> The language is Windows 1250 (ISO-8859-2).
>
> I remembered that when I tried in 8.1 to create database as same in Windows:
>
> CharSet: Win1250
> Collation: - (disabled, and it is handled as HUN - iso-8859-2)
>
> then I failed.
>
> Because in Linux (Ubuntu as I remembered) the collation with Win1250 is not
> supports, only C ordering.
> Only one possible way was that if change CharSet to UTF, then collation can
> be Windows1250...
>
> But I want to avoid the UTF hell if possible.
>
> Because now I don't have Linux here, I cannot test the PG 9.0...
>
> May Latin2 is the solution, but may Latin2 is also supports only C
> collation.

On Linux you can use locale hu_HU.iso88592.  It should do what you want.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: constraint partition issue
Next
From: "David Johnston"
Date:
Subject: DO Statement Body Parameters