Strange Case with LIKE

[Karl Grob]

I just found another problem: 'Like' works only correct up to 4 letters.

len(w) > 4 returns only 1 result even if there is much more of it

Am 12.09.2013 um 08:02 schrieb Karl Grob <kgrob at mus.ch>:

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