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.
- Re: [sqlite] retrieving integers and long John Stanton
-