Opinion on NLS_SORT settings

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Wed, 30 Jun 2004 14:33:06 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C5187D9243@ex2003.metratech.com>

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
NLS_COMP =3D ANSI (default is binary)

Is there any drawback of using the above settings at database level or it is better to create function-based indexes for UPPER comparisons.

Thanks
--Harvinder

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Jun 30 2004 - 13:29:59 CDT