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

[Doncho N. Gunchev]

Anisa wrote:
> 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?
Are you still interested in such a script? I did one for myself when 
migrating from 4.6 to 4.7 and it does not care about table names or 
prefixes - converts anything. (CC me directly, I don't read the list too 
often)

-- 
Kind Regards,
  Doncho.