Re: Linux, Hungarian charset (Win1250) is supports the hungarian collation?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Durumdara <durumdara(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Linux, Hungarian charset (Win1250) is supports the hungarian collation?
Date: 2011-03-23 23:12:14
Message-ID: 1300921934.15640.2.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-03-24 00:33:11 DO Statement Body Parameters
Previous Message Tom Lane 2011-03-23 22:00:57 Re: constraint partition issue