non-casesensitive like - search

[Ruslan Zasukhin]

On 6/12/06 11:05 PM, "thomas doppler" <doppler at derlichtblick.at> wrote:

Hi Thomas

> hi,
> 
> what settings i have to do to my db if i need a non-casesensitive search
> with "like %searchterm%"

> i'm using vmd 2.1, mac + win

Valentina 2 do not have yet feature of 1.x no_case.

Do you need case-insensitive searches always ?
If yes then you can set for your db

    db.CollationAttribute( kStrength ) = kPrimary

With this option all indexes and all searches will be case-insensitive


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