nlssort strange behaviour (bug?)

Greetings,

I run a 8.1.7. database with the following settings:

nls_lang=HUNGARIAN
nls_sort=HUNGARIAN
nls_comp=ANSI

The correct alphabetical order in the Hungarian language is A,Á,B,.... and for basic queries Oracle knows it, I can verify it using queries like "select * from dual where 'A'>'Á'" which gives no results and with 'B'>'Á' which results in an X. So far so good. The same query with 'BÁ'>'BA' results in an X which is good. 'BÁ'>'BAC' gives no results, which is bad, since Á is the second character in the string, while C is the third, according to how I order strings BÁ would come later than BAC. If I check nlssort('BÁ','NLS_SORT=HUNGARIAN') and nlssort('BAC','NLS_SORT=HUNGARIAN'), the second is greater, I think that is what causes this misbehaviour.

Do I know something wrong or is this a bug which may have been corrected already?

Any answers are highly appreciated, please cc it to hegyvari_at_ardents.hu.

Regards,

Hegyvari Krisztian Received on Sat Nov 09 2002 - 13:32:56 CET