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 >> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql