Hi Thanks for your response Konstantin. So if I am understanding you correctly the problem is that every SMSC is responding according to their own specific implementation. So for timestamps I will need to implement something such as a column with a default value.
Thanks for your input. On Tue, Jun 29, 2010 at 11:53 AM, Konstantin Vayner <[email protected]>wrote: > 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, >> >> >
