MySQL Error: Illegal Mix of Collations on Imported Database AfterScript Update

I was doing some testing before upgrading a vBulletin 3.8.4 board to vB 4.0.1, for that I downloaded the MySQL database of the forum using phpMyAdmin , created a new database on a different hosting account & imported the database there. Next I run the upgrade script & all worked fine, till I accessed my upgraded testing forum & tried to open some pages, I got the following MySQL error: Database error in vBulletin 4.0.1: Invalid SQL: ... MySQL Error : Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' Error Number : 1267 ... I thought 1st the error was caused by the MySQL version (4.1.X) or by a bug in vBulletin itself, or by the "character set" I have chosen to export & then import the database in phpMyAdmin . That's why I exported / imported the DB several times using different "character sets" & restarted the upgrade process, even setup a 2nd testing site on a different