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

Reply via email to