I want to know the type of a column, ie.: INTEGER, TEXT, REAL or BLOB
There seems to be no function to do this. I can get the "declared type" of a column but that's not easy to decipher as SQL has a zillion data types. I tried "sqlite3_column_type()" but that function only works when there's a valid row (and when there's a valid row it fails when a column is empty!) Is there any way to get the column type?