Trying to compare 2 MySQL databases, received collation error

in SQL Compare
mysql compare illegal mix of collations for operation union