NLS_SORT and NLS_COMP

  • From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 29 Jun 2004 09:17:36 -0400

Hi,

We are porting our application from SQL Server to Oracle and since we
use case insensitive sorting in SQL Server so we also have to implement
case insensitive searches in Oracle at the database level. We are
thinking of setting the following values while creating database or
particular instance:
NLS_SORT =3D binary_ci=20
NLS_COMP =3D ANSI (default is binary)

Is there any drawback of using the above settings otherwise we might
need to create lot of function-based indexes for UPPER comparisons.

Thanks
--Harvinder
=20

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts:

  • » NLS_SORT and NLS_COMP