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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql