SQLite Forum

Type of the column
Login
Hi, Ryan,
Thank you for confirming that it will work as intended, even though you don't say what the intention is. ;-)

However, my thought was to write smth like:

case SQLITE_INTEGER:
    sqlite_column_int(....);
    break;
case SQLITE_INTEGER64:
    sqlite3_column_int64(...);
    break;

because as you wrote originally, sqlite3_column_int() appears more efficient:

[quote]
(These happens to be smaller space-wise, more space-efficient to transfer in say an internet stream, and also used to be faster to do calculations with on older 32-bit systems, hence still prevailing through esp. legacy code.
[/quote]

Hopefully now you see the reason for my original question - I just wanted to make sure I'm not missing anything.

TY for sticking with me and sorry for poor explanation in the OP.

BTW, is there a reason code is not preformatted on this forum? Either with usual [code[[/code] tags, "{{{ }}}" or simply SO way with backticks?

BTW2, is there a simple way to quote you in my reply?