List:General Discussion« Previous MessageNext Message »
From:Hartmut Holzgraefe Date:May 20 2014 1:38pm
Subject:Re: Case sensitivity
View as plain text  
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/
Thread
Case sensitivityLarry Martell20 May 2014
  • Re: Case sensitivityReindl Harald20 May 2014
  • Re: Case sensitivityHartmut Holzgraefe20 May 2014
    • Re: Case sensitivityLarry Martell20 May 2014
      • Re: Case sensitivityHartmut Holzgraefe20 May 2014
        • Re: Case sensitivityLarry Martell20 May 2014
          • Re: Case sensitivityReindl Harald20 May 2014
            • Re: Case sensitivityJohan De Meersman21 May 2014
              • Re: Case sensitivityHartmut Holzgraefe21 May 2014
                • Re: Case sensitivityReindl Harald21 May 2014
                • Re: Case sensitivityLarry Martell21 May 2014