Re: Case sensitivity

2014-05-21 Thread Johan De Meersman
- Original Message - From: Reindl Harald h.rei...@thelounge.net 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

Re: Case sensitivity

2014-05-21 Thread Hartmut Holzgraefe
On 05/21/2014 08:14 AM, Johan De Meersman wrote: 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? right, the above will only change the default for new

Re: Case sensitivity

2014-05-21 Thread Reindl Harald
Am 21.05.2014 10:50, schrieb Hartmut Holzgraefe: On 05/21/2014 08:14 AM, Johan De Meersman wrote: 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? right,

Re: Case sensitivity

2014-05-21 Thread Larry Martell
On Wed, May 21, 2014 at 4:50 AM, Hartmut Holzgraefe hart...@skysql.com wrote: On 05/21/2014 08:14 AM, Johan De Meersman wrote: 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

ANN: MySQL Performance Monitoring

2014-05-21 Thread Mick Emmett
Greetings MySQL users -- If MySQL monitoring is something you are doing with one specific tool -- or not at all -- then you might find this blog post on MySQL Performance Monitoring in SPM worth a read: http://wp.me/pwdA7-Xo We frequently hear from organizations across industries who tackle