Ah! That helps. At least I have a hint. Thanks for the pointer.
-- wyan
On Jul 26, 2006, at 4:07 PM, John Stanton wrote:
Wyan wrote:
I'm calling sqlite3_column_type() to get the type, and, for a
number (20), it returns SQLITE_INTEGER. I'm guessing this covers
int, long, and long long. Is there any way to distinguish which
one it is, so I can know to call the right sqlite3_column_()
function? I've got some higher level code over this, and I'd
like to be able to get the type that's actually in the database.
Thanks,
-- wyan
You can also retrieve the declared type, which (thanks to manifest
typing) is not necessarily the same as the actual stored type. If
you are interfacing to another system you are very likely to need
the declared type and sometimes perform conversions to reverse out
what Sqlite decided to do based on the actual data.