Strange Case with LIKE

[Ivan Smahin]

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