Thread: sorting (fwd)

sorting (fwd)

From
Joel Burton
Date:
This was sent directly to me. Can anyone offer any help to Marcin?

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington

---------- Forwarded message ----------
Date: Tue, 8 May 2001 11:08:39 +0200
From: Marcin Wasilewski <marcingrupy@poczta.onet.pl>
To: Joel Burton <jburton@scw.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'tsort correctly as it schould be. 

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

Best regards
Marcin Wasilewski



--