It’s my understanding that sqLite accepts any value in any field type, whereas mySQL will toss an error and reject the SQL statement. Correct me if I am wrong, it’s happened before.
Bob S > On Jan 31, 2015, at 12:44 , Peter Haworth <[email protected]> wrote: > > On Sat, Jan 31, 2015 at 11:41 AM, Brahmanathaswami <[email protected]> wrote: > >> FYI: those interested in this date/time enhancement can add their thoughts >> here: >> >> http://quality.runrev.com/show_bug.cgi?id=4636 >> > > Just added one minor note. The separator between date and time can be the > letter "T" as well as a space. SQLIte allows this, not sure about other > implementations. > > Pete > lcSQL Software <http://www.lcsql.com> > Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and > SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
