List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:May 20 2014 1:35pm
Subject:Re: Case sensitivity
View as plain text  
Am 20.05.2014 15:26, schrieb Larry Martell:
> 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?

and what collation have your tables and databases?
what collation is the client *really* using?

set collation_connection='utf8_general_ci';

what is in the servers environment variables and in the
cli-client don't say that much about applications and in
doubt your application should *always* set charset/collation


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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