Incoming & Sent SMS content decode in sent_sms table in sqlbox

Rasika Udayanga <[email protected]>
Newsgroups gmane.comp.mobile.kannel.user
Message-ID <[email protected]>
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.