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.