Case insensitive LIKE search

[Dave Addey]

Gah!  I meant Primary - in fact, I am using Primary - I just typed
"Secondary" by accident in my email.  Sorry!

Dave.

> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Wed, 14 Dec 2005 20:34:09 +0200
> To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
> Conversation: Case insensitive LIKE search
> Subject: Re: Case insensitive LIKE search
> 
> On 12/14/05 8:20 PM, "Dave Addey" <listmail1 at dsl.pipex.com> wrote:
> 
>> 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
> 
> Check again. As I remember
> 
>     Primary    -- case-insensitive and accent-insensitive
> 
>     Secondary  -- case-insensitive but accent-sensitive
> 
>     TERTIARY   -- case-sensitive and accent-sensitive
> 
> (but may be I am wrong)
> 
> So it sounds like you need Primary.
> 
> 
>> searching now - which is *great*!  Now I can search for bjork without having
>> to remember how to get the umlaut over the o :-)
> 
> -- 
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina