Re: [sqlite] storing unsigned 64 bit values
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 or > something else ? > > Simon. > It's declared as a unsigned integer sqlite> .schema mytable CREATE TABLE IF NOT EXISTS "mytable" ( "id" integer NOT NULL PRIMARY KEY, "bigvalue" integer unsigned NOT NULL UNIQUE ); ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] storing unsigned 64 bit values
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 1.84467440737096e+19 The problem that I have is retrieving the value using c bindings. I'm calling sqlite3_column_int64. This function returns back a sqlite3_int64 value, which is signed. When I call the function it returns back 9223372036854775807, which is the maximum size of a signed 64 bit integer (one less than 2 to the power of 63) There doesn't seem to be a sqlite3_column_uint64 function. Any ideas? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users