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

Updated