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.