On 10/13/2019 5:11 PM, Shawn Wagner wrote:
The documentation for a column with NUMERIC affinity says
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.
"Lossless and reversible" here clearly means that the numerical value is
preserved, not that the exact text representation is. Thus, a couple paragraphs down in
the same article, you'll find
"A string might look like a floating-point literal with a decimal point and/or
exponent notation but as long as the value can be expressed as an integer, the NUMERIC
affinity will convert it into an integer. Hence, the string '3.0e+5' is stored in a
column with NUMERIC affinity as the integer 300000, not as the floating point value
300000.0."
It is clear in this example that '3.0e+5' will in fact get coerced to a number,
and that number will *not* in fact be rendered as '3.0e+5' when converted back
to text.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users