[support] Script to change collation on all mysql tables?

A lot of people, upgrading from 4.6 to 4.7, or having phpmyadmin issues, are interested in a script or some sort of file that will change the collation to utf8_general_ci on all tables. Anyone have any ideas? I want to add it to the handbook. I think it would be pretty easy to make a sql thingy for default tables, how do you deal with prefixes? Anisa. OOO! How about a list of tablenames in the handbook... -- ********************************* www.AnimeCards.Org 16,000 scans and counting! *********************************