Change mysql collation from latin to utf8 – all tables and all columns

Sharing is caring!

Change mysql collation from latin* to utf8 can be done by simply stop being a lazy bastard and, take the time to change the default mysql collation for the new databases you create… But what can I say, I’m a lazy bastard after all. I keep doing the same mistake over and over again. Just like every one you, because I’m bored to change the default collation of mysql.

Anyways, I had to face that problem again, for the nth time, so I decided not to be a bored-motherfuckin’-admin for once. I’ve created this php script which scans all tables and all respective columns, trying to change the damn latin-swedish “thing” to the fabulous utf “thing”.

Don’t thank me… I try to keep it humble. :Ρ



This site uses Akismet to reduce spam. Learn how your comment data is processed.