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 AJDJ(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?