On 6/27/2018 6:56 PM, Mark Wagner wrote:
I recently pointed out that sqlite doesn't enforce type names and
constraints when creating tables but I was unable to explain/justify this
behavior.
https://sqlite.org/datatype3.html
SQLite attempts to be maximally compatible with a wide variety of database
engines, and those use all kinds of naming conventions for their data types.
SQLite itself doesn't really have column data types - at least, not in the
traditional sense. It has a concept of type affinity.
To this end, SQLite accepts any sequence of names, optionally followed by one
or two numbers in parentheses, as a valid column type:
https://sqlite.org/syntax/type-name.html . These names and numbers are largely
ignored, except to the extent that a column type affinity is gleaned from them
via a simple substring match.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
