In SQLite a column declared INTEGER has integer affinity: the text '12' is stored as the integer 12, but 'abc' is stored as text without an error. Each value carries its own type. STRICT tables enforce the declared type.