SQLite Forum

Select of text that matches scientific notation format automatically converted to number
Login
When I use a column declared as BLOB to save a number like "1.234567890E9", when I output it, why it turns out to be "1234567890.0"?

How to change the format so that SQLite can output it as how I input?

And why it's followed by ".0"?