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 SQLite. Is it possible to read values exactly as they were?
Example: CREATE TABLE IF NOT EXISTS 'test' (`testcol` INTEGER); INSERT INTO 'test' (`testcol`) VALUES ('1111'); SELECT * from 'test'; and I get 1111.0 "1111" is a name (not a number) for me. "1111.0" is also a valid "name" for me therefore I can't truncate .0 by myself - prefer to read exact value from SQLite. Any help apreciated Regards, Krzysztof