Oracle case sensitivity

[#1]

My application (WizSource Source Control) comes in PB10 and PB10.5 versions and is designed to work with various databases.

I have come across a problem with Oracle which appears to be caused by queries being case sensitive.

I am pretty sure there is a session command I can use to change it to case insensitive but what exactly the command is, I don't know.

I would appreciate it if an Oracle guru could give an example.

Thanks,

Roland

[Former Member]

I have these notes that i made for making Oracle case insensitve:

ALTER SYSTEM SET NLS_COMP=LINGUISTIC SCOPE SPFILE;

ALTER SYSTEM SET NLS_SORT=BINARY_AI SCOPE SPFILE;

also, make your indexes case insensitive too, like this:

create index index_name on table_name (NLSSORT (column_name, 'NLS_SORT=BINARY_CI') );

==============================

the performance of my app dropped to a such a degree that i didn't implement these changes.