SQLite Forum

Select of text that matches scientific notation format automatically converted to number
Login
Well, firstly is "1.234567890E9" a text string or a number?

Assuming that your quotes do not indicate text, then the inherent type of that ASCII character sequence is floating point.  This is because it contains (1) a decimal point; and, (2) an exponent.

The "number" is stored as a floating point number exactly and precisely as specified.  When it is output, the floating point number is output exactly.

However, some UI function is "converting" the actual floating point binary number into something that your eyes can consume in a manner that is "pretty" for your sensibilities.  If you do not like the prettification then you are free to prettify the IEEE-754 binary64 floating point bytes in whatever fashion you find scratches your itches.

The actual stored byte sequence is x'41D26580B4800000'.  It could be output in this format, but that would cause consternation to a wider degree than using "common output prettification".

This is simply how computers work.  If you want the computer to work differently you may cause it to do so by programming it differently.