# Type Affinity

say it: **“TYP uh-FIN-ih-tee”** **/taɪp əˈfɪnɪti/**

Columns suggest types but don't enforce them.

## What is **Type Affinity**?

SQLite uses **type affinity**: a column suggests a type, but a value of another type can still be stored, unless the table is STRICT.

Level: Apprentice · [More SQLite terms at this level](https://www.ask-codey.com/glossary?category=sqlite&level=2)

Updated: November 17, 2026

Source: https://www.ask-codey.com/glossary/type-affinity
