Thread: Linux, Hungarian charset (Win1250) is supports the hungarian collation?
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
Re: Linux, Hungarian charset (Win1250) is supports the hungarian collation?
From
Peter Eisentraut
Date:
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.