I have 2 servers, one is running 5.5.25a and the other 5.0.77. They both have the same collation and character set:
mysql> SELECT COLLATION(VERSION());
+----------------------+
| COLLATION(VERSION()) |
+----------------------+
| utf8_general_ci |
+----------------------+
1 row in set (0.00 sec)
mysql> show variables like '%_server';
+----------------------+----------+
| Variable_name | Value |
+----------------------+----------+
| character_set_server | utf8 |
| collation_server | utf8_bin |
+----------------------+----------+
2 rows in set (0.00 sec)
Yet the 5.5.25a server is case sensitive as you would expect, but the 5.0.77 is not. How can I make the 5.0.77 server case sensitive?