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
--
Hartmut Holzgraefe, Principal Support Engineer (EMEA)
SkySQL - The MariaDB Company | http://www.skysql.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
