Insert the msgdata field in binary instead of hex.
On Wed, Apr 19, 2017 at 7:43 PM, Amelye Chatila <amec...@gmail.com> wrote: > Hi, > > > Any reply on this, > > > Regards, > > Amelye > > > On Tue, Apr 11, 2017 at 4:15 PM, Amelye Chatila <amec...@gmail.com> wrote: > >> Hi all, >> >> >> Not able to send unicode message, receiving scrambled content. This issue >> is on production and I was able to reproduce on testing environment >> >> *INSERT Statement:* >> >> INSERT INTO `kannel`.`send_sms` (`sql_id`, `momt`, `sender`, `receiver`, >> `udhdata`, `msgdata`, `time`, `smsc_id`, `service`, `account`, `id`, >> `sms_type`, `mclass`, `mwi`, `coding`, `compress`, `validity`, `deferred`, >> `dlr_mask`, `dlr_url`, `pid`, `alt_dcs`, `rpi`, `charset`, `boxc_id`, >> `binfo`, `meta_data`) VALUES >> (92553, NULL, 'TEST', '255765154235 <0765%20154%20235>', NULL, >> '%D9%85%D8%B1%D8%AD%D8%A8%D8%A7+%D9%83%D9%8A%D9%81+%D8%AD%D8%A7%D9%84%D9%83', >> NULL, 'smppone', NULL, 'smppone', NULL, NULL, NULL, NULL, 2, NULL, NULL, >> NULL, 31, 'b6981681-13c8-11e7-82b6-06cba1bf0ce7', NULL, NULL, NULL, >> 'utf-8', 'sqlbox', NULL, NULL); >> >> >> >> *Content on msgdata Column: *(this what get inserted on this column and >> I think the issue starts here) >> >> 254439253835254438254231254438254144254438254138254438254137 >> 2B2544392538332544392538412544392538312B25443825414425443825 >> 4137254439253834254439253833 >> >> *Environment:* Kannel SMS Gateway-1.5.0 installed on CentOS Linux 7 ( >> Core ) with mysql Ver 15.1 Distrib 5.5.52-MariaDB >> >> >> >> *Content on msgdata Column: *(On different environment and Kannel >> Version) This get sent fine . . . >> >> %06E%061%06-%06(%06'%00+%06C%06J%06A%00+%06-%06'%06D%06C >> >> *Environment:* Kannel SMS Gateway-1.5.0 installed on Ubuntu 15.04 ( >> vivid ) with mysql Ver 14.14 Distrib 5.6.28 >> >> >> >> Thanks In Advance >> >> Amelye >> > >