Case insensitive LIKE search

[Dave Addey]

I have tried again, and it seems to be working fine for me now.  I think I
had not set the collation attribute correctly.  With the strength set to
kSecondary, it now performs case-insensitive and accent-insensitive
searching now - which is *great*!  Now I can search for bjork without having
to remember how to get the umlaut over the o :-)

Thanks,

Dave.

> From: Frank Schima <macsforever2000 at goodeast.com>
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Wed, 14 Dec 2005 11:14:46 -0700
> To: Valentina Developers <valentina at lists.macserve.net>
> Subject: Re: Case insensitive LIKE search
> 
> 
> On Dec 14, 2005, at 10:59 AM, Ruslan Zasukhin wrote:
> 
>> 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.
> 
> Guys, it works fine for me. My database has Secondary collation and
> my LIKE searches are indeed not case sensitive both with and without
> the wild card (%) symbol.
> 
> Using V4RB 2.1b13 but it has worked since at least 2.0.5.
> 
> 
> Best regards,
> Frank Schima
> 
> I'm currently job hunting:
> <http://homepage.mac.com/macsforever2000/resume.html>
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina