Tweet
Fetching/Saving mail doesn't work in specific case
Hello,
I have an issue with fetching mail that has trademark symbol in its body. Import fails at MySQL part with error:
[2019-12-31 08:58:05] Espo.ERROR: EmailAccount 5bac913bca7e325f8 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xAE Corp...' for column 'body_plain' at row 1 [] []
Firstly I thought it may be charset for column body_plain but it isn't.
Also, if I forward that same mail from i.e. web mail client, ESPO is able to save it without errors and trademark symbol doesn't make troubles.
Any suggestions on how to resolve this?
I have a solution that may work by using beforeSave hook and get rid of trademark symbol but that's just awkward solution...
I have an issue with fetching mail that has trademark symbol in its body. Import fails at MySQL part with error:
[2019-12-31 08:58:05] Espo.ERROR: EmailAccount 5bac913bca7e325f8 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xAE Corp...' for column 'body_plain' at row 1 [] []
Firstly I thought it may be charset for column body_plain but it isn't.
Also, if I forward that same mail from i.e. web mail client, ESPO is able to save it without errors and trademark symbol doesn't make troubles.
Any suggestions on how to resolve this?
I have a solution that may work by using beforeSave hook and get rid of trademark symbol but that's just awkward solution...