Valentina db

[Bob Sneidar]

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 <pete at lcsql.com<mailto:pete at lcsql.com>> wrote:

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