Generally, in c# the string Equals() method will perform case-sensitive string comparison. If we want to perform case insensitive string comparison, we need to use the OrdinalIgnoreCase property and the Equals method .
Read moreAre char variables case-sensitive?
The CHAR and VARCHAR types are not case sensitive by default , but may be declared as BINARY to make them case sensitive. ENUM , SET , and TEXT columns are not case sensitive. BLOB columns are case sensitive. (See the table in Recipe 4.1.)
Read more