sorting (fwd)

This was sent directly to me. Can anyone offer any help to Marcin?

--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington

---------- Forwarded message ----------
Date: Tue, 8 May 2001 11:08:39 +0200
From: Marcin Wasilewski <marcingrupy(at)poczta(dot)onet(dot)pl>
To: Joel Burton <jburton(at)scw(dot)org>
Subject: sorting

Hello,

I have problem with Postgresql 7.0.3 installed on Solaris 8 with CDE 1.4.
I live in Poland so I would like to use my locales.
They're set correctly to pl_PL.ISO8859-2, I can type Polish characters like etc.
When I want to sort something by cat file | sort - it's done ok.

The problem starts here.
I have compiled the POSTGRES with --enable-locale --with-odbc, it was compiled and installed ok.
I create a new db and type psql - but after that I cannot type any of the Polish characters.
For example when I press ALT+L it schould be , but it's 3.

I tried to create separate file under vi with query that is including insert into table xxx values with Polish characters. The query executes correctly and insert values into table.
Then I can see Polish characters by selecting * from table, but when I want to select * from table order by column -it doesn't sort correctly as it schould be.

Can you help me, because it's very urgent to me.

Best regards
Marcin Wasilewski

--