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 forI 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 aI just wish you would stop your bully-pulpit answers.
> good policy.
> It is only one step removed from making all searches using theWhat 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.