RE: sqlbox: save SMS in readable format

2014-04-26 Thread Rene Kluwen
Did you try to select UNHEX(msg_data) as unencoded? 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

Re: sqlbox: save SMS in readable format

2014-04-26 Thread spameden
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

RE: sqlbox: save SMS in readable format

2014-04-26 Thread mozzee
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