Case insensitive LIKE search

[Ruslan Zasukhin]

On 12/14/05 6:57 PM, "jda" <jda at his.com> wrote:

>>> kStrength I have assigned (kPrimary)?
>> 
>> But if you have assign or db Strength to be Primary,
>> then LIKE respect this of course!
>> 
> 
> Hm, I have my db set to
> 
> CollationAttribute(EVColAttribute.kStrength) = EVColAttributeValue.kSecondary
 
> But LIKE searches are still case sensitive

Ivan, can you clarify ?

I believe we have solve this 3 months ago.

> (I have to surround the
> text with % to get case *insensitive* searches).

Hmm. % -- this is wild card symbol. It not affect sensitivity.

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