Good Evening.
SCHEMA: SOMECOLUMN TEXT I use the API as always: ColType := sqlite3_column_type(Pointer(FHandle), I); This has always worked fine for me and type returned was SQLITE_TEXT however lately I noticed that a particular table this is sometimes returned to me as SQLITE_NULL, even though I can clearly see there is text in there, which has caused me to proceed to even if type is null get the size and load it into a string for now, the problem is just that if the field is a blob and I am not supposed to read it as text I would have a problem.. I could use the pragma api on the table to determine the type it was declared with but the problem is as it is SQL statements I don't always know what table the column belongs to. Can someone give me some light on this matter please.
