case-insensitive searches

[Ruslan Zasukhin]

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



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]