On 05/20/2014 03:26 PM, Larry Martell wrote: > 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? >
please provide the output of SHOW VARIABLES LIKE 'character_set_%'; and SHOW VARIABLES LIKE 'collation_%'; and explain what exactly you mean by "is case sensitive". Are you referring to database and table names being case sensitive here, or to comparisons (=, LIKE) on textual values? Seeing a few example queries and the different results returned by 5.0 and 5.5 would sure help, too ... -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL - The MariaDB Company | http://www.skysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
