Thank, but unhex is not showing the message properly. Perhaps spameden is right, its related to encoding and chart-set. All my SMS are in Arabic and when I try to unhex its appears like
G'J 3(*HF #F' 9(/'DHG'( 'D2F'*J EF ,F2H1 AJ DJ(J' #F' F-( ('(' H E'E' H #.*J H F'1H*H From: spameden [mailto:spame...@gmail.com] Sent: Saturday, April 26, 2014 3:30 PM To: Rene Kluwen Cc: Moazzam Ali; users@kannel.org Subject: Re: sqlbox: save SMS in readable format 2014-04-26 14:26 GMT+04:00 Rene Kluwen <rene.klu...@chimit.nl>: Did you try to select UNHEX(msg_data) as unencoded? It won't work. msgdata is URLencoded depending on the encoding, basically url_encode feature was implemented to prevent problems with different encodings and escaping characters before inserting into Database. I've tried looking into kannel/sqlbox source-code to implement escaping instead of urlencoding but I don't have enough skills in C to do it properly. From: users [mailto:users-boun...@kannel.org] On Behalf Of moz...@gmail.com Sent: donderdag 24 april 2014 19:50 To: users@kannel.org Subject: sqlbox: save SMS in readable format How can we save SMS in readable format in MySQL instead of urlencoded hex?