case-insensitive searches

[Charles Yeomans]

On Jun 29, 2005, at 3:36 AM, Ruslan Zasukhin wrote:

> On 6/29/05 1:52 AM, "Charles Yeomans" <yeomans at desuetude.com> wrote:
>
> Hi Charles,
>
>> I've got a text field that is indexed by words.  In V4Rb 1, to do a
>> case-insensitive search I needed to define a method field and search
>> it.  Is this still the case in V4Rb 2, or can I now do something like
>>
>> SELECT textField from ATable WHERE Lower(textField)="foo" ?
>
> This should work in 2.0.
>
> Also please look at example
>
>     API/IndexByWords
>
> It demonstrate use of new feature db.Collation(),
> Which allow you make the whole db to be case-insensitive

Hmmm... lots to learn.
Thanks.

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