The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: comp.databases.oracle.server
From: Galen Boyer <galenbo...@hotpop.com>
Date: 28 Nov 2003 19:23:11 -0600
Local: Fri, Nov 28 2003 8:23 pm
Subject: Re: Case insensitive queries
On Fri, 28 Nov 2003, damor...@x.washington.edu wrote: How then should they get a case-insensitive query to execute? > Galen Boyer wrote: >> Sure, the data is case-sensitive, but it would be damn nice >> for the database to allow the developer the ability to turn it >> off or on based on query needs. > I disagree completely. When 10g is released I will advise my Would you want them to do it the old-fashioned way..., and how old-fashioned should it be? > A properly designed application should force valid case for I would ask you to read my posting again. I'm not asking the > inserts and updates. database to somehow turn everything to a single case for storage purposes or fix my very poorly designed DML strategies for me. I'm talking about case-insensitive queries. I am forced, because of a limitation in Oracle, to either store a single-cased version of all queriable columns used in searches, or I must explicitly ask Oracle to function index a particular single-cased version and then use that function in my search queries. I would rather just be able to tell Oracle, hey, in this query, > Covering up for a bad design or bad implementation is not a I just wish you would stop your bully-pulpit answers. > good policy. > It is only one step removed from making all searches using the What efforts are those and more valuable to whom? > SOUNDEX function or making all columns VARCHAR2(4000). > So is it a limitation? Absolutely. Is it one I am glad Oracle -- You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||