Forums posts garbled after moving servers

What could have caused text to get garbled like this?

A bÑ–kеr stоps by thе lоÑal Harleу Shоp to have hÑ–s bÑ–ke fixеd. Thеу cоuldn't do Ñ–t whÑ–le he wаіtеd, ѕо hе saÑ–d he didn't lÑ–vе far аnd wоuld just wаlk home. On the way hоmе hе stopped аt the hardwаrе store аnd bought a buÑkеt аnd an anvÑ–l. He stоpped bу the feed Ñ•tоre/lÑ–veÑ•tock dеаlеr аnd ріcked uÑ€ acоuÑ€le of Ñhickеns аnd a goose. Hоwevеr, strugglÑ–ng

 

I tried to run the follow query after doing some Googling, but it didn't help:

SELECT CONCAT('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') as stmt
FROM `information_schema`.`TABLES` t
WHERE 1
AND t.`TABLE_SCHEMA` = 'database_name'
ORDER BY 1

Of course, 'database_name' was replaced by my database name.

Quote · 20 Oct 2012

I also tried the following with no success:

ALTER DATABASE bikerun_unity CHARACTER SET utf8 COLLATE utf8_general_ci;# 1 row affected.

ALTER TABLE bx_forum_post CHARACTER SET utf8 COLLATE utf8_general_ci;# 149 rows affected.

Quote · 20 Oct 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.