[V4RB2] What's wrong with SQLSelect?

[Ruslan Zasukhin]

On 3/30/05 3:26 PM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:

> On 3/30/05 4:08 AM, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:
> 
>> You can e.g. For db assign
>> 
>>     db.CollationAttrinute( kStrength ) = kPrimary
>> 
>> Then all sorting and searches will ignore case and accents.
>> 
>> In the same time I think LIKE search will ignore this.
>> I think it is good idea to make LIKE search aware about that settings also.
> 
> Where and how do I make the LIKE search aware of this?

LIKE will ignore this for now.

Ivan right now work to improve this and allow LIKE to see our db/table
collations settings.

Also we have found that LIKE (as well) as REGEX can be speedup a lots if a
field is indexed.

This task also will be solved in the nearest days.


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