Are string functions case-sensitive?

For binary strings ( BINARY , VARBINARY , BLOB ), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic characters, comparisons are case-sensitive .