> It would also be a file format change, rendering about 1e12 existing database files obsolete.
Maybe, but maybe there could be some clever implementation which doesn't break compatibility. I don't know about the exact internals of how SQlite stores values in the file. But I think there must be some identifier that tells whether a value is binary, integer, or float. Wouldn't it be possible to store both values, binary float and decimal float, in such a way that older versions would just read the binary float and ignore the additional data? Then, newer versions could read either, according on whether PRAGMA DECIMAL_MATH=TRUE is set or not. Just an idea, don't know whether this would be feasible or not. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
