Re: nls_sort=binary_ci

janu <angani_at_gmail.com> wrote:
> If I do a select on database_properties and v$parameter, I see a
> difference. Could you please explain what might be?
>
> select * from database_properties where property_name like '%SORT%'
>
> NLS_SORT BINARY Linguistic definition
>
> select name, value from v$parameter where name like '%sort%'
>
> nls_sort BINARY_CI

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14225/applocaledata.htm#i637232

Yours,
Laurenz Albe Received on Thu Dec 07 2006 - 05:06:16 CST