List:General Discussion« Previous MessageNext Message »
From:Larry Martell Date:May 21 2014 11:07am
Subject:Re: Case sensitivity
View as plain text  
On Wed, May 21, 2014 at 4:50 AM, Hartmut Holzgraefe <hartmut@stripped> 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
> individual text columns?
>
> right, the above will only change the default for new columns
> added later, but existing columns will keep their current
> character set and collation.
>
>   ALTER TABLE tbl_name
>     CONVERT TO CHARACTER SET charset_name
>     [COLLATE collation_name]
>
> is needed to change the default *and* all already existing
> columns

Thanks for all the help Hartmut.
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