SqlSelect doesn't find text in textfield

[Ruslan Zasukhin]

On 9/23/08 5:25 PM, "Bart Pietercil" <bart.pietercil at cognosis.be> wrote:

>> res = gDB.SqlSelect( "SELECT Kapitel, Lauftext, zielFrame FROM
>> Seiten_de
>> WHERE lower(Kapitel) LIKE '%" &
>> Valentina.EscapeString(lower(searchTerm),1) & "%' OR
>> Lauftext LIKE '%" &  Valentina.EscapeString(lower(searchTerm),1) &
>> "%'",
>> #kServerSide, #kReadWrite, #kRandom )
>> 
> 
> But I think you really need to read up on
> 
> http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documenta
> tion:vkernel:database:locale&s=collation
> 
> remember that collation can be set on each level (db, tb, field) and
> that they can override (field has precedence and so on)
> I think you are after kStrength = kSecondary

And this is another good right way, if it is okay to have the whole
db/table/field to be with case-insensitive searches

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