Datatypes (continued)

Page 23 of 41
[prev] [next]

Column Affinity - values try to convert to the column type if they can do so without loss of information
- Integer
- Numeric
- Text
- None

Strict Affinity Mode:
- Raises an exception if values cannot converted into the column type
- Makes SQLite work more like statically typed databases
- Not yet implemented

If type declaration contains...	Then the affinity is...
"INT"	Integer
"CHAR" or "CLOB" or "TEXT"	Text
"BLOB" or there is no type declaration	None
Otherwise	Numeric