SQLite Forum

Why was there no error message at CREATE TABLE?
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 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