Re: [sqlite] storing unsigned 64 bit values

2018-10-01 Thread Jens Alfke
> On Sep 27, 2018, at 3:53 AM, Conor Lennon wrote: > > The problem that I have is retrieving the value using c bindings. > I'm calling sqlite3_column_int64. > ... > When I call the function it returns back 9223372036854775807, which is the > maximum size of a signed 64 bit integer (one less

Re: [sqlite] storing unsigned 64 bit values

2018-09-27 Thread Keith Medcalf
ner >Sent: Thursday, 27 September, 2018 11:50 >To: SQLite mailing list >Subject: Re: [sqlite] storing unsigned 64 bit values > >On Thu, Sep 27, 2018 at 11:05:24AM -0600, Keith Medcalf wrote: > >> so the only way to store something [larger than a signed 64-bit >int]

Re: [sqlite] storing unsigned 64 bit values

2018-09-27 Thread Nathan Wagner
On Thu, Sep 27, 2018 at 11:05:24AM -0600, Keith Medcalf wrote: > so the only way to store something [larger than a signed 64-bit int] > is as a double-precision float. I'd like to point out that you could *store* it as the hex or decimal text representation of the integer. If you included

Re: [sqlite] storing unsigned 64 bit values

2018-09-27 Thread Keith Medcalf
-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Conor Lennon >Sent: Thursday, 27 September, 2018 10:10 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] storing unsigned 64 bit values > > > &

Re: [sqlite] storing unsigned 64 bit values

2018-09-27 Thread Simon Slavin
On 27 Sep 2018, at 5:10pm, Conor Lennon wrote: > It's declared as a unsigned integer There is no such thing in SQLite. SQLite has an integer type, but it is an 8-byte signed integer. If you don't need to sort on that

Re: [sqlite] storing unsigned 64 bit values

2018-09-27 Thread Conor Lennon
On 27/09/18 17:03, Simon Slavin wrote: > On 27 Sep 2018, at 11:53am, Conor Lennon wrote: > >> e.g. 18446744073709551615 (one less than 2 to the power of 65) >> >> I seem to have managed to store this value in a database. > What is the affiliation for that column ? Did you declare it as INTEGER

Re: [sqlite] storing unsigned 64 bit values

2018-09-27 Thread Simon Slavin
On 27 Sep 2018, at 11:53am, Conor Lennon wrote: > e.g. 18446744073709551615 (one less than 2 to the power of 65) > > I seem to have managed to store this value in a database. What is the affiliation for that column ? Did you declare it as INTEGER or something else ? Simon.

[sqlite] storing unsigned 64 bit values

2018-09-27 Thread Conor Lennon
I am trying to store and retrieve unsigned 64 bit integer values in sqlite through c bindings. e.g. 18446744073709551615 (one less than 2 to the power of 65) I seem to have managed to store this value in a database. When I run sqlite3 on the command line and select the column, I get back