Field Value Comparison in SOQL WHERE Clause

Select Name,First_Name__c From Candidate__c Where First_Name__c='mAnju'

From the above query, we are trying to retrieve records from Candidate object only if 'First_Name__c' field value is matching with 'mAnju'.

Now, the question here is, the field value comparison is case-sensitive or case-insensitive? 
The answer is already there in the above screenshot while creating the field if we select Unique with Case-sensitive combination then SOQL will also compare value(s) case-sensitively and return the results.

Note:

1. The above case-sensitive rule is not just for ‘=’ operator, it also applies to LIKE, IN, NOT IN.

2. We can’t use “Long Text area or Encrypted field datatypes in WHERE clause for comparison, it will results in an error.

tHiNk gooD and dO thE bEsT.........MANJU NATH 🌝