Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

nls_sort with expanding character not working?

dario-2280378May 27 2011 — edited May 30 2011

on my Oracle 11.2.0.1, I'm using XCROATIAN as a NLS_SORT parameter.

I made my own list of characters and separate table of words wich I tried to test for sorting (nls_territory=croatia, nls_language=croatian, both session and instance).

I created a table (only one field: rijec - nvarchar2(20)) with words:
djiber
Djiber
Điber
điber

"dj" is expanded characters of "đ" and "Dj" are expanded characters of "Đ".

so, as I supposed, a query like:

select * from ab_test where nls_lower(rijec, 'NLS_SORT=XCROATIAN')='điber'

should retun all records, because they're all the same as small words (in croatian), but.. query returns only:
Điber
điber

(it's also same with NLS_SORT=CROATIAN)
like, there's no notification it's expaning character..
or am I wrong?

Edited by: 846417 on 27-May-2011 14:19

This post has been answered by Sergiusz Wolicki-Oracle on May 29 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2011

Added on May 27 2011

#database-key-features, #globalization-support

3 comments

279 views