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
signature.asc
Description: OpenPGP digital signature