What is the size in bits of your UNSIGNED BIG INT? SQLite supports only SIGNED integers in 32 and 64 bits, so to properly store/retrieve UNSIGNED values you need to typecast.
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. -----Ursprüngliche Nachricht----- Von: Filip Curcic [mailto:curcic.fi...@gmail.com] Gesendet: Freitag, 06. September 2013 13:21 An: sqlite-users@sqlite.org Betreff: [sqlite] UNSIGNED BIG INT in SQLite 3.7.11. Hello, I am using Android 4.2 with SQLite 3.7.11 database. I am not being able to insert UNSIGNED BIG INT data properly. It looks to me like an overflow, because when I read it out I get a negative number. That only happens on this device, I have another 2.3 Andriod device which runs older version of SQLite, and it does not happen. Is this maybe a known problem? Thank you -- Filip Curcic _______________________________________________ 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
