View Single Post

   
  #6 (permalink)  
Old 04-08-2008, 11:55 AM
Laurenz Albe
 
Posts: n/a
Default Re: nls_sort=binary_ci

janu <angani@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/c...ta.htm#i637232

Yours,
Laurenz Albe
Reply With Quote