The column type is declared as `NONE` which means that the column data (and comparands) will be converted to NUMERIC (INTEGER or REAL) if they "look like a number". So when the value '2E5' is stored in the database, the INTEGER 200000 is stored, not the text string. The type keyword meaning "don't do any conversions" is either "BLOB" or not having a type keyword.