Wyan <[EMAIL PROTECTED]> wrote:
On Jul 26, 2006, at 12:39 PM, Jay Sprenkle wrote:
On 7/26/06, Wyan <[EMAIL PROTECTED]>
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.
You can call any of the column functions. They convert the database
data to the type for each function type. You can even call a text()
function
to retrieve a textual representation of a numeric column.
Right. But I want to be able to determine the type.
SQLite does not internally distinguish between different sizes of
integer. You have already determined the type - it's SQLITE_INTEGER.
If you are concerned about losing significant bits, just always use
sqlite3_column_int64 to retrieve an integer value.
Igor Tandetnik
