Sort problem

From: Michal Motalík <motalik_at_labsys.cz>
Date: Fri, 23 Nov 2001 14:27:29 +0100
Message-ID: <9tleeb$44v$1@news.telecom.cz>

Hello,

I have following problem on Oracle 8.1.7.

Lets have simple table:

tst_tbl (name varchar2(10))

It contains following data

'11111'
'AAAAA'
SELECT * FROM tst_tbl WHERE name >= '-' ORDER BY name returns:
'AAAAA'
'11111'

SELECT * FROM tst_tbl WHERE name >= 'AAAAA' ORDER BY name returns:
'AAAAA'
But second query should also return '11111' row.

I experienced this when NLS_SORT parameter is CZECH. I think it is bug or am I wrong?

Michal Motalík Received on Fri Nov 23 2001 - 07:27:29 CST