Is MySQL case sensitive?

Question

Table names are stored in lowercase on disk and name comparisons are not case-sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases.

Does MySQL care about case?

This means database and table names are not case sensitive in Windows, and case sensitive in most varieties of Unix.

Is MySQL varchar case-sensitive?

The CHAR and VARCHAR types are not case sensitive by default, but may be declared as BINARY to make them case sensitive.

Is MySQL replace case-sensitive?

REPLACE() function is case-sensitive.

How do I make MySQL case-sensitive?

When searching for partial strings in MySQL with LIKE you will match case-insensitive by default*. If you want to match case-sensitive, you can cast the value as binary and then do a byte-by-byte comparision vs. a character-by-character comparision. The only thing you need to add to your query is BINARY .

Expert · Answer