On Fri, Oct 31, 2014 at 8:06 AM, Bob Sneidar <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
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
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

Reply via email to