On 30 Jul 2015, at 3:04pm, hawk <hawk at rybnet.pl> wrote:
> CREATE TABLE IF NOT EXISTS 'test' (`testcol` INTEGER);
> INSERT INTO 'test' (`testcol`) VALUES ('1111');
> SELECT * from 'test';
>
> and I get
> 1111.0
Igor pointed out one problem: you explicitly defined the column as INTEGER,
therefore SQL is handling values as numbers. Try again but this time use TEXT
instead of INTEGER.
The other problem is in your programming. I assume you are retrieving the
value returned from the SELECT and storing it in a floating point variable or
handling it as a floating point number. If you use the SQL command-line shell,
which doesn't make assumptions about values, everything works correctly.
<https://www.sqlite.org/cli.html>
Simon.
