Hi, For big integers, INTEGER is not an option as for >64bit signed integers it leads to conversion to and storage as DOUBLE.
The only reliable datatype I can see now for big integers is TEXT. This is a bit unfortunate though as for <=64bit signed integers, more optimizations would be possible. Introduce a datatype EXACT, that's the same as NUMERIC just that the INTEGER/REAL conversion is done only if *all* digits are preserved? Thanks! Mikael http://www.sqlite.org/datatype3.html : A column with NUMERIC affinity may contain values using all five storage > classes. When text data is inserted into a NUMERIC column, the storage > class of the text is converted to INTEGER or REAL (in order of preference) > if such conversion is lossless and reversible. For conversions between TEXT > and REAL storage classes, SQLite considers the conversion to be lossless > and reversible if the first 15 significant decimal digits of the number are > preserved. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
