I'm running the database upgrade from zc_install and got the following error ...

Code:
1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'
in:
[CREATE TABLE zen_counter_history_clean as SELECT * FROM zen_counter_history WHERE 1 GROUP BY startdate COLLATE latin1_general_ci;]
I see in phpMyAdmin that my tables are utf8_unicode_ci and type MyISAM.

What is your recommendation on getting the database upgraded?