2009/9/2 Sebastian Bermudez <sebastian.bermu...@yahoo.com>: > hi! i have an table ( articles ) with a column for EAN13 Barcodes like ( > 7790080066784). > I have created the column with Integer data type... ( i have chose that data > type after read the SQLITE DOC where it' say: "INTEGER. The value is a signed > integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of > the value.") but when i insert this value for that column... i get 0 (cero) > stored in that place...
SQLite version 3.6.16 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> sqlite> create table tst( c1 integer ); sqlite> sqlite> insert into tst values( 7790080066784 ); sqlite> sqlite> select * from tst; 7790080066784 sqlite> No apparent problem... > > > Have any idea ? You need to provide more information on what you are doing. > > Att. > Sebastian > > PD: Sorry i don't study english > Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
