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
