What is the difference between:
MYCOLUMN NUMERIC Vs MYCOLUMN INTEGER Or does it really mean nothing, I remember somewhere the default column type could be integer, after that it defaults to whatever you insert. But I was wondering... what would the preferred type be to A: Store Int32 - Int64 values B: Floating point values. Is there a way to alter SQLite so that a select would always return a column as a type you want? Either in the DB file or as part of the select. Thank you.