Goals
We want MySQL distinct to use case sensitive grouping because by default MySQL use case insensitive.
Solution of MySQL DISTINCT case sensitive
We can use binary operator to convert the character set.
SELECT DISTINCT CAST(expr as BINARY)As an alternative we can just use BINARY.
SELECT BINARY expr
