"Nicolas Gaiffe" <nicolas.gai...@gmail.com> wrote in message news:a729b91e0904140537p7f97fae0q7f2afcb327e55...@mail.gmail.com > By the way, it seems INTEGER are stored on 2 to 8 bytes (from > http://theopensourcery.com/sqlitedocs/sqdatatype3.html ). What about > 16-byte integers ?
SQLite doesn't support those. > Do I have to declare them as REAL to store them ? That's one option, but note that you'll lose precision. REAL is stored as 64-bit IETF floating point value, which has 52 mantissa bits (so not even all 64-bit integers can be exactly represented, let alone 128 bits). You could store such integers as BLOBs, but then you won't be able to do any math on them within SQL. Or, you could store them as two 64-bit integers (high and low halves in two separate columns), then you could do some math but it'll be rather awkward. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
