- Original Message -
> From: "Reindl Harald"
> Subject: Re: Case sensitivity
>
> ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE
> latin1_general_ci;
Purely from memory, doesn't that change the table but add the old setting to
individual text columns?
I seem to recall run
Am 21.05.2014 00:48, schrieb Larry Martell:
>> 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
>> t
On Tue, May 20, 2014 at 5:52 PM, Hartmut Holzgraefe wrote:
> On 05/20/2014 11:10 PM, Larry Martell wrote:
>
>> 5.5 server:
>>
>> mysql> select distinct(pnlCurrency) from PnLDetail;
>> +-+
>> | pnlCurrency |
>> +-+
>> | USD |
>> | USd |
>> +-+
>>
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(pn
On Tue, May 20, 2014 at 9:38 AM, Hartmut Holzgraefe wrote:
> 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 VARIA
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_%'
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_
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 s
