From the (linked) sqlite docs: "In SQLite, the datatype of a value is associated with the value itself, not with its container." And on the topic of specifica

From the (linked) sqlite docs: "In SQLite, the datatype of a value is associated with the value itself, not with its container." And on the topic of specifically inserting "a" into an INTEGER column: "If the TEXT value is not a well-formed integer or real literal, then the value is stored as TEXT"