case-insensitive searches

[Charles Yeomans]

On Jul 2, 2005, at 4:47 PM, Ruslan Zasukhin wrote:

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

Confirmed.
>
> Do you have records already in db/tables?

Yes, and that appears to be the problem.  I was eventually able to 
create a new database file with collation set to ignore case.  But it 
appears that changing the collation of an existing database doesn't 
work.  I have entered it into Mantis.

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