Case insensitive LIKE search

[Ruslan Zasukhin]

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]