Of course it does. But if the OP inserted his as yet unspecified large value using the sqlite3_bind_int() call, then the shell would render it as a negative value. He needs to use the sqlite3_bind_int64() interface instead...
-----Ursprüngliche Nachricht----- Von: Richard Hipp [mailto:d...@sqlite.org] Gesendet: Freitag, 06. September 2013 16:04 An: General Discussion of SQLite Database Betreff: Re: [sqlite] UNSIGNED BIG INT in SQLite 3.7.11. On Fri, Sep 6, 2013 at 10:00 AM, Hick Gunter <h...@scigames.at> wrote: > > My guess is that you have exceeded the range of a 32 bit integer > (0x7FFFFFFF) which will be rendered as a negative number by the SQLite > shell. > The shell works just fine with 64-bit signed integers: SQLite version 3.8.0.1 2013-08-29 17:35:01 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select 1024*1024*1024*1024*1024; 1125899906842624 -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -------------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users