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"