I hesitated when adding that bit, but I seem to remember reading somewhere that was the case. As you say, it matters not.
Bob S On Oct 31, 2014, at 10:02 , Peter Haworth <p...@lcsql.com<mailto:p...@lcsql.com>> wrote: On Fri, Oct 31, 2014 at 8:06 AM, Bob Sneidar <bobsnei...@iotecdigital.com<mailto:bobsnei...@iotecdigital.com>> wrote: sqLite is very forgiving when it comes to type constraints. This is because the data is literally stored as text no matter what type the column is. Where mySQL might throw an error for storing the wrong type of data, sqLite will store whatever you tell it to. You're right about SQLite not enforcing data types, but the data is not always stored as text. Not that it really matters since the file level accessing is all handled by the SQLite library. Pete _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
