Re: UTF-8 Unicode SMS Scrambled

2017-04-20 Thread 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 
wrote:

> Insert the msgdata field in binary instead of hex.
>
>
> On Wed, Apr 19, 2017 at 7:43 PM, Amelye Chatila  wrote:
>
>> Hi,
>>
>>
>> Any reply on this,
>>
>>
>> Regards,
>>
>> Amelye
>>
>>
>> On Tue, Apr 11, 2017 at 4:15 PM, Amelye Chatila 
>> 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
>>>
>>
>>
>

Re: UTF-8 Unicode SMS Scrambled

2017-04-20 Thread Manas Mohanty 
Insert the msgdata field in binary instead of hex.


On Wed, Apr 19, 2017 at 7:43 PM, Amelye Chatila  wrote:

> Hi,
>
>
> Any reply on this,
>
>
> Regards,
>
> Amelye
>
>
> On Tue, Apr 11, 2017 at 4:15 PM, Amelye Chatila  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
>>
>
>

Re: UTF-8 Unicode SMS Scrambled

2017-04-19 Thread Amelye Chatila 
Hi,


Any reply on this,


Regards,

Amelye

On Tue, Apr 11, 2017 at 4:15 PM, Amelye Chatila  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
>

UTF-8 Unicode SMS Scrambled

2017-04-11 Thread 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