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
> [email protected]
> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
