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.