BitSet operations

[Ruslan Zasukhin]

On 5/10/06 12:08 AM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

>>     FindVlaue -- find EXACT match
>> 
> Well it doesn't find an exact match either when more then 1 capital in a
> word, and otherwise it do find "exact" without caring about case. So if
> search is "abds" it also finds "Abds" but not "ABds", if search is "ABds" it
> finds "abds", "Abds" but not "ABds"?

But you talk about CASE INSENSETIVE SEARCH !!!
 
You need set correct CollationAttrubute for you database.

    db.CollationAttribute( kStrength ) = kPrimary

Check docs please.


> Also, when search in numeric field of records it finds nothing in records
> with a string field having more then 1 capital letter in a word.
> 
>>     FindStartWith() - find strings that START WITH ...
>> 
>> Please check this point.
>> 
> I have not used the string functions her as I was interested in an exact
> (case less) match and there is no specific string function returning an
> exact match so I "assume" FindValue and FindValueAsArraySet also should work
> with straings in this case?
> 
>> Also note that you can control if db/table/fied should do
>> case-sensitive  or case-insensetive searches and sorting. Use
>> for this db.CollationaAttribute
>> 
> I haven't looked at this one though, guess it is as default, but should it
> have any impact on numeric searches? The "main" problem is that numeric
> searches also doesn't work if a string field has 2 or more capitals in same
> word. With word I mean string field can be like "Alice Springs" is 2 words,
> if this is "Alice Springs" no search what so ever work on that record.

Numeric searches DO NOT depend on collation. Only strings.

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