May be in your program; From the 3.7.10 shell sqlite> select id, start_time from exports; d006dacf-3134-45b6-828b-0860738e4029|1311178875028 sqlite> select id, cast(start_time as integer) from exports; d006dacf-3134-45b6-828b-0860738e4029|1311178875028 sqlite>
What version are you running? Regards, Noah -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of yesnid Sent: Thursday, February 09, 2012 9:43 AM To: sqlite-users@sqlite.org Subject: 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,131117893502 8,'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-los ing-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 CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
