NLS case insensitive in real life

Oracle 10g, (solaris). Does anyone have any 'real life' experience with using the new features to perform case insensitive searches? Outside of what can be easily gathered from googling sites such as http://www.orafaq.com/node/999.

Developers are starting to get interested in utilizing alter session changes.

alter session set NLS_COMP=ANSI;
alter session set NLS_SORT=BINARY_CI;

Now NLS_COMP='LINQUISTIC';

Or, Creating a function based index, etc. create index ind_idemo_sname_ci

   on invoice_demo (nlssort(supplier_name, 'NLS_SORT=BINARY_CI'))

Trying to anticipate.

Joel Patterson
Database Administrator
904 727-2546

--
http://www.freelists.org/webpage/oracle-l