SQLite’s Flexible Typing: Storage Types and Column Affinity

Automated excerpt

This column can only store integer values. SQLite determines column affinity by inspecting the declared SQL type in the CREATE TABLE statement. If the declared type contains the substring INT, the column receives INTEGER affinity.

Selected automatically from source text; not independently written or fact-checked. Read the original for full context.