Re: [sqlite] retrieving integers and long

[John Stanton]

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.