Re: nls_sort=binary_ci

janu wrote:
> Hi Laurenz A,
>
> I set my system setting to BINARY_CI
>
> sql>alter system set nls_sort=binary_ci scope=both;
>
> My question is ,why there is difference between database_properties and
> V$parameter.
>
> Thank you
> RA

I'm guessing what you are seeing is the difference between how Oracle sorts (binary) and whether it uses case insensitivity (binary_ci). This varies based on which sql verbs you are using (see metalink Note:263083.1). Since nls_sort is the collating sequence used, Oracle must somehow keep track of all the derivations of it. Perhaps the bug is both views should have both attributes. What happens when you set your language to, say, CATALAN?

This certainly could be documented better, perhaps an SR is in order, we shouldn't have to guess.

jg

--
@home.com is bogus.
http://www.engadget.com/2006/12/12/lumus-optical-unveils-microdisplay-packin-designer-glasses/