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