Mass update of all database,table,columns for Collation?

[Chris]

Has anyone ever accomplished a mass update off all databases, tables and
columns for collation?

If I try to change the collation/character set for the mysql daemon it
breaks all of our queries because they conflict with the swedish default
that they have been created with. The problem is we have about 90 databases
with hundreds of tables. Is there an easy way to update all of these at once
and that would allow me to start with the correct default at startup.

Thanks

Chris

[Bill Karwin]

Chris wrote:

Has anyone ever accomplished a mass update off all databases, tables and
columns for collation?

I would do this with a script. Dump a list of all your databases and
tables with mysqlshow. Then use a script (Perl or whatever) to loop
through the table names, and format all those hundreds of statements,
one for each table that needs updating.

I don't know any elegant way of doing this with a single statement. But
since I assume you don't need to do it frequently, an inelegant solution
works just as well.

The time it takes to write the script is probably less than the time it
would take to research a "better" way to do it.

Regards,
Bill K.