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 <ras...@bellvantage.com> 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
