Valentina db

[Peter Haworth]

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