On 27/09/18 17:03, Simon Slavin wrote: > On 27 Sep 2018, at 11:53am, Conor Lennon <clen...@druidsoftware.com> 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