As of now we have a trigger for logon which changes these both parameters to binary but i want a permanent solution to this.
create or replace trigger trigger_testnls
after logon on database
begin
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_COMP=BINARY' ;
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_SORT=BINARY' ;
end;
Can anyone help?