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.

Reply via email to