case-insensitive searches

[Charles Yeomans]

On Jul 2, 2005, at 2:34 AM, Ruslan Zasukhin wrote:

> On 7/2/05 1:24 AM, "Charles Yeomans" <yeomans at desuetude.com> wrote:
>
>>> Well,
>>>
>>> It looks that you expect that IF field is indexed by words, than
>>>
>>>     SELECT textField from ATable WHERE Lower(textField)="foo"
>>>
>>> Will find you record with "foo too roo doo" ?
>>>
>>> NO.
>>>
>>>     Because Lower(textField)='foo'     // by the way, single quotes
>>>     will not do indexed search.
>>>     it will do simple SCAN of column.
>>>
>>>     and it can find only record with "foo", "FOO", "fOO" values
>>
>> I expect that Valentina can do anything :)
>
> I need to think more on this :-))
>
>> But for now I will use method fields as I have been.
>
> Charles, but any problems with db.collationAttribute ?

Good question; I decided to try that.  I'll see how it works.

--------------
Charles Yeomans