"unsigned" is ignored by sqlite. Depending on how you inserted the value, it could be stored as a text or as a real value, irrespective of the declared type.
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Conor Lennon Gesendet: Donnerstag, 27. September 2018 18:10 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] 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 <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 ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
