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