Vbulletin Upgrade: Illegal mix of collations

I just had the pleasure of upgrading from vBulletin 3.8.5 to 4.1.3 on a forum I support.
Upon doing this on the dev server I ran into a problem right away during the upgrade.

MySQL Error : Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Upon looking into this more, this is caused by exactly what it says. Your database has a mix of different collations, in my case, utf8_unicode_ci & utf8_general_ci.
Now there was about a 50/50 split between tables and columns with either one of these collations, which would take FOREVER to change 1 by 1.

So i dug and dug and found an awesome php script that will connect to your database and change the collation of ALL tables and colums for you. This made things a breeze and the upgrade worked after.

Here is what I did. Make sure you BACKUP YOUR DATABASE first.
Step 1: Download the Phoca Changing Collation script.
Step 2: Extract it.
Step 3: Upload the index file to your host. Put it in an easy to remember dir, i called mine “phoca”.
Step 4: Run the script from your browser by entering it’s url path. In my case http://www.mydomain.com/phoca
Step 5: Enter your database credentials and the collation you want the tables converted to. I kept mine as the default utf8_unicode_ci.
Step 6: Run the script. Once it finishes your done, the upgrade should now work.
Make sure to remove the script and dir from your server when your done.