SMF Support > Install and Upgrade Help   (1/4) > >>  when i want
to post  on my shout box, it tells me Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for
operation 'ifnull' File:
/home/u369350200/public_html/Sources/Subs-Portal.php Line: 1251
Note: It appears that your database may require an upgrade. Your
forum's files are currently at version SMF 2.0.2, while your
database is at version 2.0.1. The above error might possibly go
away if you execute the latest version of upgrade.php  how can i
stop this?  How did you upgrade from 2.0.1 to 2.0.2, was it
through the SMf admin interface or by uploading the files to
your server?  Through smf admin interface.  It basically means
that there is a check being run on your database and one of the
values being used has an encoding of utf8_unicode_ci and the
other value has an encoding of utf8_general_ci which is why your
getting the error. You'll need to have a look at your database
and see what the default encoding is for the overall