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 configuration. like mo-recode? > > > > Regards > Anshu Sah > > > > > On Sat, Mar 24, 2012 at 7:56 PM, Willy Mularto <[email protected]> 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 <[email protected]> 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 ID Type Time Sender Receiver SMSC ID BOX ID UDH >>> Message >>> 4f6b6ccb-e653-4731-8b4f-635ce02ac25c MT-PUSH 2012-03-24 17:39:03 >>> SAFETY XXXXXXXXX XXXXXXXXXX sqlbox >>> 0053006500610074002000620065006C00740073002000730061007600650020006C006900760065007300200061006E00640020007200650064007500630065007300200069006E006A00750072006900650073002E004200750063006B006C0065002000750070002000650076006500720079002000740069006D006500200079006F0075002000640072006900760065002000610020006300610072002D002000490073007300750065006400200069006E0020007000750062006C0069006300200069006E0074006500720065007300740020006200790020004D0069006E002E0020006F006600200052006F006100640020005400720061006E00730070006F0072007400200026002000480069006700680077006100790073002C00200047006F00760074002E0020006F006600200049006E006400690061 >>> >>> >>> >>> Regards >>> Anshu Sah >>> >>> >> >> Willy Mularto >> F300HD+MR18DE (NLC1725) >> >> >> >> >> >> >> >> >> >> > > Willy Mularto > F300HD+MR18DE (NLC1725) > > > > > > > > > > Willy Mularto F300HD+MR18DE (NLC1725)
