UTF-8 Unicode SMS Scrambled

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

UTF-8 Unicode SMS Scrambled

Amelye Chatila
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', 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)

2544392538352544382542312544382541442544382541382544382541372B2544392538332544392538412544392538312B254438254144254438254137254439253834254439253833

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
Reply | Threaded
Open this post in threaded view
|

Re: UTF-8 Unicode SMS Scrambled

Amelye Chatila
Hi,


Any reply on this,


Regards,

Amelye

On Tue, Apr 11, 2017 at 4:15 PM, Amelye Chatila <[hidden email]> 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', '<a href="tel:0765%20154%20235" value="+255765154235" target="_blank">255765154235', 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)

2544392538352544382542312544382541442544382541382544382541372B2544392538332544392538412544392538312B254438254144254438254137254439253834254439253833

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

Reply | Threaded
Open this post in threaded view
|

Re: UTF-8 Unicode SMS Scrambled

manas mohanty-2
Insert the msgdata field in binary instead of hex.
 

On Wed, Apr 19, 2017 at 7:43 PM, Amelye Chatila <[hidden email]> wrote:
Hi,


Any reply on this,


Regards,

Amelye


On Tue, Apr 11, 2017 at 4:15 PM, Amelye Chatila <[hidden email]> 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', '<a href="tel:0765%20154%20235" value="+255765154235" target="_blank">255765154235', 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)

2544392538352544382542312544382541442544382541382544382541372B2544392538332544392538412544392538312B254438254144254438254137254439253834254439253833

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


Reply | Threaded
Open this post in threaded view
|

Re: UTF-8 Unicode SMS Scrambled

Web Services
Hello,

what error you receive or what message you receive on cell ??

thnx

On Thu, Apr 20, 2017 at 11:35 AM, Manas Mohanty <[hidden email]> wrote:
Insert the msgdata field in binary instead of hex.
 

On Wed, Apr 19, 2017 at 7:43 PM, Amelye Chatila <[hidden email]> wrote:
Hi,


Any reply on this,


Regards,

Amelye


On Tue, Apr 11, 2017 at 4:15 PM, Amelye Chatila <[hidden email]> 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', '<a href="tel:0765%20154%20235" value="+255765154235" target="_blank">255765154235', 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)

2544392538352544382542312544382541442544382541382544382541372B2544392538332544392538412544392538312B254438254144254438254137254439253834254439253833

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