2009/7/15 Dieter Dasberg <[email protected]>: > Hello, > . . . > > This > > create table test (Afield INTEGER) > > leads always to a data-size of 4 byte,
What makes you think this? See http://www.sqlite.org/datatype3.html > what I need is a data-size of 8 byte. > > What can I do? > > Best regards, > > Dieter SQLite version 3.4.2 Enter ".help" for instructions sqlite> create table tst( data integer ); sqlite> insert into tst( data ) values( 1 ); sqlite> insert into tst( data ) values( 9223372036854775807 ); sqlite> insert into tst( data ) values( 9223372036854775808 ); sqlite> sqlite> sqlite> select data, typeof( data ) from tst; 1|integer 9223372036854775807|integer 9.22337203685478e+18|real sqlite> Regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
