MyBB Community Forums

All quotations marks for a forum I converted for a friend are turning into â. Any ideas?

Hello,

Not sure but have you enabled UTF-8 on conversion? If not, may be the issue.

Ok, it seems that this is the problem. When I try to convert through the admin panel it gives me this error.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blobNOT NULL, CHANGE `shout_ip` `shout_ip` varbinary(30) DEFAULT '' NOT NULL, CH' at line 1
Query:
    ALTER TABLE mybb_mysb_shouts CHANGE `shout_msg` `shout_msg` blobNOT NULL, CHANGE `shout_ip` `shout_ip` varbinary(30) DEFAULT '' NOT NULL, CHANGE `hidden` `hidden` varbinary(10) DEFAULT '' NOT NULL 

You should install MyBB with a UTF-8 database and import the phpBB database without checking "convert to UTF-8"