From oracle-l-bounce@freelists.org Mon Aug 8 19:30:08 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j790U8LZ006501 for ; Mon, 8 Aug 2005 19:30:08 -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 j790U6IP006490 for ; Mon, 8 Aug 2005 19:30:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E18351DD4EC; Mon, 8 Aug 2005 19:30:03 -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 20431-07; Mon, 8 Aug 2005 19:30:03 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 678EA1DD601; Mon, 8 Aug 2005 19:30:03 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=QqBUQJOMDp2fzPzkmKnGaT7+MFQ2l8N2Ty80vo7BwC2JUCQDi59vl69qBtyw82c3vsF74E2uTW9onop10Y6uQfZCOnFufv7HTPfb3rSGiryQaBENku7ZRmvc5qhX5WQ4etroVCAE25ijKxqmRwXPraj+4cGv3kv5EVvhs5Tdfug= Message-ID: Date: Mon, 8 Aug 2005 18:28:10 -0600 From: Walt Weaver To: oracle-l@freelists.org Subject: Re: case sensitivity - database setting? In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: X-archive-position: 23597 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: weaver1308@gmail.com Precedence: normal Reply-To: weaver1308@gmail.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=-1.4 required=5.0 tests=AWL,BAYES_00, FROM_ENDS_IN_NUMS autolearn=no version=2.63 You got a lot of really good replies, but they all fix the problem on the application side. They're no good to you. Tell your application vendor to go to hell and find another one. They're idiots. --Walt Weaver (who feels obligated to post once every 6 months, mostly in lower case) Bozeman, Montana On 8/8/05, J. Dex wrote: > 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 > -- http://www.freelists.org/webpage/oracle-l