case-insensitive searches

[Ruslan Zasukhin]

On 7/2/05 11:42 PM, "Charles Yeomans" <yeomans at desuetude.com> wrote:

>>> Charles, but any problems with db.collationAttribute ?
>> 
>> Good question; I decided to try that.  I'll see how it works.
> 
> In fact I cannot get this to work.  I set
> 
> theDB.CollationAttribute(EVColAttribute.kStrength) =
> EVColAttributeValue.kPrimary
> 
> but the next time the database file is opened,
> theDB.CollationAttribute(EVColAttribute.kStrength) returns 2.
> 
> I also tried setting this property and reindexing the database
> immediately before searching using a query like
> 
> SELECT textField from ATable WHERE textField="foo"
> 
> and it failed as well.

Hmm.

Please check our example IndexByWords.
It works correctly.

Do you have records already in db/tables?

-- 
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]