How to use SQLite 3 type affinity?

Question

According to SQLite 3 documentation says it has "type affinity" feature to enforce column data types. But how to turn it on?

Answer 1

Type affinity does not force column data types - it simply makes a suggestion as to how the underlying storage engine stores the data.

Under the "type affinity" section:

The type affinity of a column is the recommended type for data stored in that column. The important idea here is that the type is recommended, not required. Any column can still store any type of data.

(emphasis added)

As far as "how to turn it on," there's no such thing. This is how SQLite works all the time. There's nothing to turn on or off in order to get this functionality.

Answer 2

The column data types are not enforced, just suggested by their declared types in the create table statement. This is what they mean by type affinity.

The type affinity of a column is the recommended type for data stored in that column. The important idea here is that the type is recommended, not required. Any column can still store any type of data. It is just that some columns, given the choice, will prefer to use one storage class over another. The preferred storage class for a column is called its "affinity".