SQL Searchin not case sensitive

[Steve Albin]

On Saturday, January 27, 2007 tj at quarksbar.net (Trausti Thor Johannsson) wrote:

>Hello,
>
>I have this code in my software :
>
>cursor = mDataBase.SqlSelect("select * from simptable where ((texti  
>like '%"+leitarstrengur+"%') or (filename like '%"+leitarstrengur 
>+"%'))",EVCursorLocation.kServerSide, EVLockType.kReadWrite,  
>EVCursorDirection.kRandom  )
>
>
>I would like to search for texti and not search case sensitive, so  
>people could type "php" or "PHP" or "pHp" and still get the same  
>results.  This above works quite well with other databases, but how  
>do I do not case sensitive ?
>
>
>I am using RealBasic 2007 pro on Mac.

Assuming you have the collation attribute set correctly for your database, you may be running into the same problem I had using V4RB 2.5.3.  I reported it to Mantis -   <http://www.valentina-db.com/bt/view.php?id=2156>.  The problem did not occur for me in 2.5.2 and has since been fixed in version 2.5.4.

Steve

-- 
Steve Albin - Montclair, NJ
http://www.jazzdiscography.com/
http://www.steve-albin.com/