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

From: Durumdara <durumdara(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Linux, Hungarian charset (Win1250) is supports the hungarian collation?
Date: 2011-03-21 10:22:43
Message-ID: AANLkTi=MAZ4w_WQJetVxewHZ_ej1MiOD689C4kk2_Ffy@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Everybody!

We need to choice a DB for our new project.
Two of the databases are possible to choose.

1.) PGSQL 9.x

2.) FireBird 2.x

We needs to serve 75/80 users in a time.
The client platform is Windows, Delphi based applications with [Zeos/PGDAC]
or [IBX/ZEOS].
The server is may Windows, but in other place may Linux!

I want to ask about PG, because formerly I experienced a strange thing with
it, and I need to check that is possible to use it against FB in the
project.

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.

The hungarian language have special accents. The good order is:

AÁEÉIÍOÓÖŐUÜŰ

Can anybody help me to see this in Linux and PG 9.x?

Thanks for your help:
dd

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Durumdara 2011-03-21 10:33:29 Disconnect/Resource releasing/PING
Previous Message Vibhor Kumar 2011-03-21 09:48:54 Re: query execution time