List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:May 21 2014 9:01am
Subject:Re: Case sensitivity
View as plain text  
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, 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

ah - i remember writing a script doing that for 5000 tables on the
whole infrastructure as charset/collation support started to get rid
of the ridicolous "latin1_swedish_ci" preset


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