Indexing and collation question

[Ruslan Zasukhin]

On 24/10/07 12:20 AM, "jda" <jda at his.com> wrote:

Hi Jon,

> My db and its indexes are now collated as
> kSecondary (searches are diacritic sensitive).
> 
> Some of my users are asking for
> diacritic-insensitive searches. Since I want
> indexed searches to be affected only, I thought
> that I'd add this to the main index (allFields).
> 
> allFields.CollationAttribute(EVColAttribute.kStrength)
> = EVColAttributeValue.kPrimary
> 
> This seems to work just fine and now searches for
> u also find ü (umlaut over the u).
> 
> I have to questions:
> 
> 1. Is this safe? Am I missing something obvious that might bite me later?

Yes, why not?
What can be not safe at all here?
 
> 2. Since I'm using the classes way, I'm assuming
> that this can't be changed once a db is created.

Conflict will be on db.open() because in your code it is stocked to
kPrimary.

Although generally speaking at runtime you can change it.

May be you can write your code to save it in prefs, and assign before
db.open, and change it in both in prefs and db.



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