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_%';
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/