List:General Discussion« Previous MessageNext Message »
From:Larry Martell Date:May 20 2014 1:26pm
Subject:Case sensitivity
View as plain text  
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?
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