Re: Incoming & Sent SMS content decode in sent_sms table in sqlbox

[Sayed Hadi Rastgou Haghi]

Hi,

%0D%BB%0D%C3%0D%D2%0D%9A is URL-ENCODED format of original message: Û Ã Ò Ú

i used, https://www.branah.com/unicode-converter [pasted  in  Percent
Encoding (Example: a%20%e4%b8%ad%20%d0%af)]


On Mon, Sep 23, 2019 at 7:18 PM Rasika Udayanga 
wrote:

> Dear All,
>
> Im using sqlbox for sending and receiving GSM and Unicode sms. In both
> cases msgdata stored in below format in sent_sms table in mysql database.
>
>
> %0D%BB%0D%C3%0D%D2%0D%9A
>
>
> I think above is UCS-2BE/ UTF-16BE encoded. Please assist me as to how I
> can get the original message by decoding this, preferably using a mysql
> function or a c# method.
>
>
> Tried setting alt-charset to ucs-2/ utf-8 in smsc config and enabling
> mo-record. Non of them gave me the solution.
>
>
> Appreciate your assistance in advance.
>
>
> Thanks
>
> Rasika Udayanga.
>


-- 
Sincerely,

Sayed Hadi Rastgou Haghi

Incoming & Sent SMS content decode in sent_sms table in sqlbox

[Rasika Udayanga]

Dear All,
Im using sqlbox for sending and receiving GSM and Unicode sms. In both cases 
msgdata stored in below format in sent_sms table in mysql database.

%0D%BB%0D%C3%0D%D2%0D%9A

I think above is UCS-2BE/ UTF-16BE encoded. Please assist me as to how I can 
get the original message by decoding this, preferably using a mysql function or 
a c# method.

Tried setting alt-charset to ucs-2/ utf-8 in smsc config and enabling 
mo-record. Non of them gave me the solution.

Appreciate your assistance in advance.

Thanks
Rasika Udayanga.