Mail Portlet Synchronization Issue

Liferay Portlet doesn't Synchronize all the mails properly. Though it shows the Mail Count in Pagination,the Pagination fails to work properly at a certain level.

This is due to some unusual characters in subject/sender/to/body in your mails.

You can resolve this by changing some column types from "mail_message" table.

Step 1: Please make sure that your database character set is "UTF-8".If it isn't then create it as follows:

create database testing character set utf-8



Step 2: Change "longtext" to "binary" for some column from "mail_message" table

as follows:

alter table Mail_Message modify column sender longtext character set binary;

alter table Mail_Message modify column to_ longtext character set binary;

alter table Mail_Message modify column cc longtext character set binary;

alter table Mail_Message modify column bcc longtext character set binary;

alter table Mail_Message modify column body longtext character set binary;

alter table mail_message modify column sender longtext charecter set binary