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"?
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"?