View Single Post

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

Thanks Morgan, I made the change as you recommanded.

I have one more question.

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

Thank you
RA

Reply With Quote