select unhex(msgdata) as unencoded.
From: users [mailto:[email protected]] On Behalf Of [email protected] Sent: woensdag 23 april 2014 21:57 To: [email protected] Subject: store SMS into MySQL with original text Hi, I want to store SMS with its original text into the database instead of the default encoded format. I am using UTF-8 charset due to the Arabic language requirement and all messages are ending up like msgdata:06470627064A002006330628062A064806460020062306460627002006390628062F 062706440648064706270628002006270644063206460627062A064A0020064506460020062C 064606320648063100200641064A002000200644064A0628064A062700200623064606270020 0646062D06280020062806270628062700200648002006450627064506270020064800200623 062E062A064A0020064800200646062706310648062A0648 in the database. How can I store them into readable format or how can I convert them into readable format for the reporting purpose.
