[sqlite] Retrieve a int or a sqlite_int64

Hello, Is there any way to differentiate one value persisted with sqlite3_bind_int from another persisted with sqlite3_bind_int64 ? How to know which method between sqlite3_value_int and sqlite3_value_int64 should be used to retrieve the value back ? Regards.

Re: [sqlite] Retrieve a int or a sqlite_int64

On Tuesday, May 13, 2014 12:02:27 PM gwenn wrote: Is there any way to differentiate one value persisted with sqlite3_bind_int from another persisted with sqlite3_bind_int64 ? No, there's no difference How to know which method between sqlite3_value_int and sqlite3_value_int64 should be used

Re: [sqlite] Retrieve a int or a sqlite_int64

Hello Charles, Tuesday, May 13, 2014, 3:12:09 PM, you wrote: CS Load it with sqlite3_value_int64 every time. If the number fits in a 32 bit CS integer, then you can store it in one. This is what I do. Everything is 64 bits to be future proof. CS Charles CS

Re: [sqlite] Retrieve a int or a sqlite_int64

Ok, Thanks. On Tue, May 13, 2014 at 11:59 PM, Teg t...@djii.com wrote: Hello Charles, Tuesday, May 13, 2014, 3:12:09 PM, you wrote: CS Load it with sqlite3_value_int64 every time. If the number fits in a 32 bit CS integer, then you can store it in one. This is what I do. Everything is