SQL Converting Text SMS into HEX code automatically

2012-03-24 Thread Anshu Sah
Hi I need your attention over One very critical Issue, I Inserted Text SMS But while i check kannel store page. Its HEX coded SMS Kindly Suggest what should be values for SQLBOX Send SMS table. SMS IDTypeTimeSenderReceiverSMSC IDBOX IDUDHMessage

Re: SQL Converting Text SMS into HEX code automatically

2012-03-24 Thread Willy Mularto
May we have your SQL query? On Mar 24, 2012, at 7:18 PM, Anshu Sah wrote: Hi I need your attention over One very critical Issue, I Inserted Text SMS But while i check kannel store page. Its HEX coded SMS Kindly Suggest what should be values for SQLBOX Send SMS table. SMS ID

Re: SQL Converting Text SMS into HEX code automatically

2012-03-24 Thread Anshu Sah
INSERT INTO `send_sms` ( `momt`, `sender`, `receiver`, `udhdata`, `msgdata`, `time`, `smsc_id`, `service`, `account`, `id`, `sms_type`, `mclass`, `mwi`, `coding`, `compress`, `validity`, `deferred`, `dlr_mask`, `dlr_url`, `pid`, `alt_dcs`, `rpi`, `charset`, `boxc_id`, `binfo`, `meta_data`,

Re: SQL Converting Text SMS into HEX code automatically

2012-03-24 Thread Willy Mularto
I just executed your query with no weird result. I see the msgdata is URL-Encoded, are you using HTTP SMSC? AFAIK Kannel has it owns plugin to do it outside the SQLBox. Can you try set NULL to coding and charset and let's see the result. On Mar 24, 2012, at 8:58 PM, Anshu Sah wrote:

Re: SQL Converting Text SMS into HEX code automatically

2012-03-24 Thread Anshu Sah
NO, I have urlencoded the DATA over the Application. SQLBOX automatically decode it. is there anything to do with SQLBOX configuration. like mo-recode? Regards Anshu Sah On Sat, Mar 24, 2012 at 7:56 PM, Willy Mularto sangpr...@gmail.com wrote: I just executed your query with no weird

Re: SQL Converting Text SMS into HEX code automatically

2012-03-24 Thread Willy Mularto
What SQLBox version do you use? Do you hack the SQLBox? It is weird bro, mayba Alejandro has the precise answer :) On Mar 24, 2012, at 9:42 PM, Anshu Sah wrote: NO, I have urlencoded the DATA over the Application. SQLBOX automatically decode it. is there anything to do with SQLBOX