SQLite Forum

Why was there no error message at CREATE TABLE?
Login
No.  Neither "text" or "integer" or any other datatype name
is a keyword in SQLite.
They are just identifiers.  And SQLite allows any sequence of identifiers
to be the datatype, to accommodate types like "NATIVE VARYING CHARACTER"
and "UNSIGNED SHORT INTEGER"
and whatnot.  SQLite sees "TEXT B INTEGER" as just a string of identifiers
and considers that whole string to be the datatype.

This case does, however, seem like it might be a useful new entry on the
[quirks page][1].

[1]: https://www.sqlite.org/quirks.html