SQLite Forum

Data Types
>did you define the column types when you defined the table?

The tables are defined with types for each column; I queried sqlite3_column_type() inside a user-defined function. I could equally query the column type inside a callback function ... but is is not reliable to assume the column type from the current row ... as you say, <i><b> note that SQLite does not enforce values to be the same type as a column definition.</b></i>