SQL Searchin not case sensitive

[Trausti Thor Johannsson]

Great, I will test the new version.


Trausti
On Jan 27, 2007, at 5:48 PM, Steve Albin wrote:

>
> 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/
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina