I don't know about OpenBase but with Oracle you can create an index
on upper(column)
and in fact you probably should do so if you're doing
caseInsensitiveLikes
Alan
On Feb 25, 2008, at 5:46 PM, Alex Cone wrote:
Fore OpenBase caseInsensitiveLike gets transmogrified to "like" as
that is already
case insensitive in OpenBase-land.
The problem to avoid is that often by comparing to "upper(column)"
you bypass
any indexes on that column.
The FrontBase and OpenBase plug-ins avoid this in their handling of
this query
component.
abc
On Feb 25, 2008, at 12:09 PM, webobjects-dev-
[EMAIL PROTECTED] wrote:
From: Mike Schrag <[EMAIL PROTECTED]>
OK, let me amend my reply. Still waiting for the coffee to
brew. :-) Unless the plugin does this, EOF generates Upper
(column) = Upper(value).
That excerpt I pasted was from FrontBasePlugIn ...
Yes, but there are other databases... :-)
Just clarifying -- I couldn't tell if you were responding to my post,
or to the thread in general.
ms
__alex cone
ceo c o d e f a b llc
[EMAIL PROTECTED]
212.465.8484 x101
http://www.codefab.com
If you are not living on the edge, you are taking up too much space.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/award%
40apple.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
