collations

[Ruslan Zasukhin]

On 2/5/05 4:58 PM, "Olivier" <vidal_olivier at yahoo.fr> wrote:

>> Hm, I don't see how it can. For example, in my case the collation
>> strength is set as
>> 
>> CollationAttribute(EVColAttribute.kStrength) =
>> EVColAttributeValue.kSecondary
>> 
>> This ignores case, but not accents, and works fine for SQL searches.
>> 
>> But for RegEx, case *is* considered unless I add (?i) to the search.
>> So RegEx ignores the collation strength attribute, at least in this
>> instance.
> 
> OK, thank you very much Jon.
> 
> I made tests of speed. In a lot of case, the queries with collations
> are almost also fast as without collations.
> ( Except for big selections WITH big results. There, he can have 30 in
> 50 % of difference).

You have test speed of what ?

Index search must practically NOT depend on collation,
Because even for million of records we will make max 20 comparisons.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------