Strange Case with LIKE

[Karl Grob]

There was a error in my description. In fact it is not a server. I didn't remind that this statement goes to a local DB that works as a buffer for parts of the remote DB.
So this might explain the difference.
(BTW: the server is the same for both clients. The client is different. - But see above.)

IMH this remains a error even with a local DB. With Xojo (compiled for all systems on a Mac) the versions are identical.

BTW: If I change the Collation.Strength of this buffer-DB from kTertiary to kSecondary i still get only the lowercased words (on Mac too!).
I might learn regex in the near future, but in principle my statement is (as I think) correct SQL. 
I now created a second field (in the buffer-DB), where the first is changed to lowercase. This is the 'brute force' solution.

Thanks
Karl

Am 12.09.2013 um 07:12 schrieb Ivan Smahin <ivan_smahin at paradigmasoft.com>:

> 
> On Sep 11, 2013, at 5:35 PM, Karl Grob <kgrob at mus.ch> wrote:
> 
>> I have a statement to search a list of words
>> 
>> w1 is titlecased ("Le%") , w2 lowercased ("le%")
>> 
>> ----------------
>> if w1 = "" then
>>   LCur = pufDB.SqlSelect("SELECT ** FROM wortliste")
>> else
>> 
>>    MsgBox w1 + " / " + w2
>>   LCur = pufDB.SqlSelect("SELECT ** FROM wortliste WHERE fldWort LIKE '" + w1 + "' OR fldWort LIKE '" + w2 + "'")
>> end if
>> -----------------
>> 
>> With Client Mac OS 10 the result is correct, with Client Windows (from XP to 8!) I get only the lowercased words.
>> The server runs on my iMac. In have a Mac and  Windows runs from my Mac (Parallels). I checked in XP and 8: always the same.
>> 
>> Th Message Box shows the same result in both systems, so the statement should be correct.
>> 
>> I have trouble imagining what this could be.
>> 
> 
> 
> Are vServers running on Mac and Windows the same version?
> What about run this query from vStudio against Win vServer - is it still lower-cased result only? 
> BTW, it would be better to use regexp here - instead of 2 LIKE conditions.
> 
> -- 
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>