Comparing strings case sensetively

Posts   
 
    
Posts: 87
Joined: 17-May-2011
# Posted on: 12-Oct-2011 13:22:10   

Hi there I want to compare strings case senstively for e.g. when I am comparing JoHn it should not return any of the john, John, johN

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 12-Oct-2011 15:50:21   

Your database should have case sensetive collation.

[quotenickname="docs"]FieldLikePredicate performs a LIKE compare using the case sensitivity setting of the database system the query is executed on. The SQL generated does not contain any collation information nor any case insensitive setting if the database is using case sensitive comparison operations by default (Oracle, some SqlServer installations).