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