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)
