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
>> 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