Problem is - Kannel stores the TS in different formats, depending on remote SMSC protocol and implementation. Sometimes i see numeric values, sometimes hex
So i dont think really anything but varchar would work well 2010/6/29 Nikos Balkanas <[email protected]> > Hi, > > Please consult the online Mysql reference. This is not a kannel question. > If you use varchar or even datetime type column column, you better provide > the value yourself. If you use timestamp type column, you can have mysql > initialize it to current time. > > BR, > Nikos > ----- Original Message ----- From: brett skinner > To: [email protected] > Sent: Tuesday, June 29, 2010 12:12 PM > Subject: Datatype for timestamp for mysql dlr storage > > > > Hi > > I am using the mysql dlr storage type. I have everything working except for > the timestamp. This is the output from debug mode > > sql: INSERT INTO delivery_receipts (smsc, received, source, destination, > service, url, mask, boxc, status) VALUES ('XXXYYYXXX', '50062911024679487', > '+123123123', '+123123123', 'simple', '', '31', '', '0'); > > I set the delivery_receipts table received column to timestamp but when I > query it I get this 0000-00-00 00:00:00 > > What should the datatype of the received column be? I see in some places > people have left it as varchar. Is it up to me to do the translation. > > Thanks and appreciate any assistance. > > Regards, > >
