azrul.com

1. Export jos_jomcomment from your old database (you can use phpMyAdmin). If you have another prefix on the table, like mos_ you need to open the exported file with Wordpad and replace all instances of mos_jomcomment with jos_jomcomment.
2. Drop jom_comment from your new database.
3. Import your old exported jos_jomcomment table.
4. Run the following SQL quries (you can use phpMyAdmin):
   

ALTER TABLE `jos_jomcomment` CHANGE `comment` `comment` TEXT CHARACTER SET binary NOT NULL ; ALTER TABLE `jos_jomcomment` CHANGE `comment` `comment` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

 ALTER TABLE `jos_jomcomment` CHANGE `title` `title` VARCHAR(200) CHARACTER SET binary NOT NULL ; ALTER TABLE `jos_jomcomment` CHANGE `title` `title` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `jos_jomcomment` CHANGE `name` `name` VARCHAR(200) CHARACTER SET binary NOT NULL ; ALTER TABLE `jos_jomcomment` CHANGE `name` `name` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;