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 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: > > > 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`, `logtime`) VALUES > ( 'MT', 'SAFETY', 'XXXXXXXX', NULL, > 'Seat+belts+save+lives+and+reduces+injuries.Buckle+up+every+time+you+drive+a+car-+Issued+in+public+interest+by+Min.+of+Road+Transport+%26+Highways%2C+Govt.+of+India', > NULL, 'XXXXXXX', NULL, NULL, NULL, 2, NULL, NULL, 2, NULL, NULL, NULL, 31, > '6-76-1330304-1c017a07908-4f6dd231-21056103126-4999', NULL, NULL, NULL, > 'ISO-8859-15', NULL, NULL, NULL, '2012-03-24 13:54:59'); > > > > Regards > Anshu Sah > > > > > On Sat, Mar 24, 2012 at 6:32 PM, Willy Mularto <sangpr...@gmail.com>wrote: > >> 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 IDTypeTimeSenderReceiverSMSC IDBOX IDUDHMessage >> 4f6b6ccb-e653-4731-8b4f-635ce02ac25cMT-PUSH2012-03-24 17:39:03SAFETY >> XXXXXXXXXXXXXXXXXXXsqlbox >> >> 0053006500610074002000620065006C00740073002000730061007600650020006C006900760065007300200061006E00640020007200650064007500630065007300200069006E006A00750072006900650073002E004200750063006B006C0065002000750070002000650076006500720079002000740069006D006500200079006F0075002000640072006900760065002000610020006300610072002D002000490073007300750065006400200069006E0020007000750062006C0069006300200069006E0074006500720065007300740020006200790020004D0069006E002E0020006F006600200052006F006100640020005400720061006E00730070006F0072007400200026002000480069006700680077006100790073002C00200047006F00760074002E0020006F006600200049006E006400690061 >> >> >> Regards >> Anshu Sah >> >> >> >> Willy Mularto >> F300HD+MR18DE (NLC1725) >> >> >> >> >> >> >> >> >> >> > > Willy Mularto > F300HD+MR18DE (NLC1725) > > > > > > > > > >