Is this from inside your application?
Works fine from the shell which makes me think you're truncating your value in
your program.
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE IF NOT EXISTS Exports (id varchar(50)
PRIMARY
...> KEY NOT NULL,start_time integer,end_time
...> integer,data_source_id varchar(50),format
...> integer,percent_complete integer,size integer,comment
...> varchar(50),user_id varchar(50),state
...> integer,friendly_name varchar(50),download_count
...> integer,mark_for_delete integer,udn varchar(50));
sqlite>
sqlite> INSERT INTO Exports
...>
VALUES('d006dacf-3134-45b6-828b-0860738e4029',1311178875028,1311178935028,'dvd-1',2001,0,0,'/*NoComment*/','matt',1337,'d006dacf-3134-45b6-828b-0860738e
4029',0,0,'406b8555-5ae5-496d-844c-2f839e19eb75');
sqlite>
sqlite> select * from Exports;
d006dacf-3134-45b6-828b-0860738e4029|1311178875028|1311178935028|dvd-1|2001|0|0|/*NoComment*/|matt|1337|d006dacf-3134-45b6-828b-0860738e4029|0|0|406b8555-5ae5-4
96d-844c-2f839e19eb75
sqlite>
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
________________________________
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of yesnid [ns...@pelco.com]
Sent: Thursday, February 09, 2012 11:42 AM
To: sqlite-users@sqlite.org
Subject: EXT :Re: [sqlite] Cannot insert/retrieve 8 byte integers without
losing digits
Hello Simon,
Here is my create:
CREATE TABLE IF NOT EXISTS Exports (id varchar(50) PRIMARY
KEY NOT NULL,start_time integer,end_time
integer,data_source_id varchar(50),format
integer,percent_complete integer,size integer,comment
varchar(50),user_id varchar(50),state
integer,friendly_name varchar(50),download_count
integer,mark_for_delete integer,udn varchar(50));
and here is my insert:
INSERT INTO Exports
VALUES('d006dacf-3134-45b6-828b-0860738e4029',1311178875028,1311178935028,'dvd-1',2001,0,0,'/*NoComment*/','matt',1337,'d006dacf-3134-45b6-828b-0860738e4029',0,0,'406b8555-5ae5-496d-844c-2f839e19eb75');
what winds up in the database for start and end time is:
1213849748
which is what the number 1311178875028 becomes if you cast it to an int, I
assume that I am just missing a simple thing here but can really use your
help.
Thank you,
Simon Slavin-3 wrote:
>
>
> On 9 Feb 2012, at 4:58pm, yesnid wrote:
>
>> I am having a similar issue, I am trying to store a 13 digit value in my
>> table and it is being converted to a 10 digit value? Is there something
>> that
>> I need to do, to enable the 8 byte values for integer?
>
> What type have you defined that column in the table as ? Can you supply
> the CREATE command or the relevant part of it ?
>
> How are you supplying the values to be stored ? Are you using _exec() on
> a long string, or binding them as an integer, a float, or what ?
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/Cannot-insert-retrieve-8-byte-integers-without-losing-digits-tp33243026p33295099.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
