Right. But I want to be able to determine the type.
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.