From oracle-l-bounce@freelists.org Tue Jun 29 08:15:33 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5TDF8220994 for ; Tue, 29 Jun 2004 08:15:18 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5TDEw620938 for ; Tue, 29 Jun 2004 08:15:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2E6F872C531; Tue, 29 Jun 2004 07:56:49 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04237-05; Tue, 29 Jun 2004 07:56:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 820AE72C73C; Tue, 29 Jun 2004 07:56:48 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 29 Jun 2004 07:55:13 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9745272C697 for ; Tue, 29 Jun 2004 07:55:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02791-100 for ; Tue, 29 Jun 2004 07:55:12 -0500 (EST) Received: from owa.metratech.com (mail.metratech.com [199.171.52.172]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id DD90D72C705 for ; Tue, 29 Jun 2004 07:55:06 -0500 (EST) Received: from ex2003.metratech.com ([10.10.100.18]) by owa.metratech.com with Microsoft SMTPSVC(5.0.2195.5329); Tue, 29 Jun 2004 09:17:37 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit Subject: NLS_SORT and NLS_COMP Date: Tue, 29 Jun 2004 09:17:36 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: NLS_SORT and NLS_COMP Thread-Index: AcRd2aJL1/KtHebHRLWchTjkRKnNwgAAQOBA From: "Harvinder Singh" To: X-OriginalArrivalTime: 29 Jun 2004 13:17:37.0480 (UTC) FILETIME=[7294EC80:01C45DDB] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3934 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Harvinder.Singh@MetraTech.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@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 -----------------------------------------------------------------