[sqlite] Read strings as they were

Yes, I am stupid... My example was as I thought it works. In fact there was one more step. CREATE TABLE IF NOT EXISTS 'test' (`testcol2` INTEGER); ALTER TABLE 'test' ADD COLUMN `testcol` float; INSERT INTO 'test' (`testcol`) VALUES (''); SELECT * from 'test'; Yes, I know that table was

[sqlite] Read strings as they were

Here is my problem. I have strings that "looks" like a numbers. But they aren't (at least for me). I am aware that SQLite handles types on it's own and makes conversion to INTEGER or REAL if it is possible (sqlite.org/datatype3.html). The problem is that I got ".0" at every number I put into