From oracle-l-bounce@freelists.org Mon Aug 8 11:43:13 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j78GhB5L027212 for ; Mon, 8 Aug 2005 11:43:11 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j78Gh5IP027192 for ; Mon, 8 Aug 2005 11:43:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 365AC1DD531; Mon, 8 Aug 2005 11:43:01 -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 12091-08; Mon, 8 Aug 2005 11:43:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ADD041DD460; Mon, 8 Aug 2005 11:43:00 -0500 (EST) Message-ID: X-Originating-IP: [65.54.161.208] X-Originating-Email: [cemail_219@hotmail.com] X-Sender: cemail_219@hotmail.com From: "J. Dex" To: oracle-l@freelists.org Subject: case sensitivity - database setting? Date: Mon, 08 Aug 2005 12:41:08 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 08 Aug 2005 16:41:09.0333 (UTC) FILETIME=[FAB69050:01C59C37] X-archive-position: 23566 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cemail_219@hotmail.com Precedence: normal Reply-To: cemail_219@hotmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-0.5 required=5.0 tests=AWL,BAYES_00, FORGED_HOTMAIL_RCVD2,FROM_ENDS_IN_NUMS autolearn=no version=2.63 We are setting up an application (third-party out-of the-box type) and the group that is setting it up would like to set it up so that when users search for records the searches are NOT case sensitive. Is there an Oracle database setting that would facilitate this? The application vendor said it is a database issue and has to be set on the database side. _________________________________________________________________ Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- http://www.freelists.org/webpage/oracle-l