How to change collation in entire db?

[ponsfrilus]

Hi all,
I get this error: "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) ... " and I'm looking for a way to change rapidly DATABASE, TABLES AND FIELDS COLLATION with a SQL query.

I know this query can do it for a table, but it dosen't change fields in this table and I don't know how to change it to all table in a database:
ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci

Is something like "ALTER TABLE * DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci " exists?

THanks a lot