List:General Discussion« Previous MessageNext Message »
From:Hartmut Holzgraefe Date:May 20 2014 9:52pm
Subject:Re: Case sensitivity
View as plain text  
On 05/20/2014 11:10 PM, Larry Martell wrote:

> 5.5 server:
> 
> mysql> select distinct(pnlCurrency) from PnLDetail;
> +-------------+
> | pnlCurrency |
> +-------------+
> | USD         |
> | USd         |
> +-------------+
> 2 rows in set (0.00 sec)
> 
> 5.0 server:
> 
> mysql> select distinct(pnlCurrency) from PnLDetail;
> +-------------+
> | pnlCurrency |
> +-------------+
> | USD         |
> +-------------+
> 1 row in set (0.01 sec)
> 
> Both have the same data in them.

ok, in this case the interesting piece of information
would be the "SHOW CREATE TABLE pnlCurrency;" output
from both.

As the collation_database variables differ between the
two servers ("utf8_bin" vs. "latin1_swedish_ci") I assume
that the same is the case for the actual tables, and that
would perfectly explain why one treads lower/upper case
as distinct while the other doesn't


-- 
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