mailsms issue

[sghoul]

Hi Anton, I'm having an issue when sending an email from SQL Trigger, the body of the email, in this case a phone number, is not read properly by mailsms plugin.
For the testings, I've checked the logs, at this stage, the body is being coded base64, correct till now:
L3 mailsms_hook_playsmsd # email from:[xxx xxxxx@xx.xxx] subject:[admin 9999 test test] body:[KzEzMjM0NTMzNDU4]
Afterwards, the body is not properly decoded, for instance here to: 04 which is incorrect.
L2 sendsms_queue_push # saving queue_code:b8a9a7dc2a1b15b6f6256a013dc03c50 dst:04
Please note that when sending an email from an email client / Web the mailsms plugin works perfectly.
Kindly address this issue. Thanks!

[antonraharja]

yeah I've seen this issue as well on my setup.

[sghoul]

It might be related to MSSQL database mail server encoding UTF16, whereas PlaySMS php function is decoding the body as it was UTF8?... Worth to check?