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.