Ok. my problem is my SQLITE front end (SQLITE ADMINISTRATOR v 0.8.3.2) ... show me 0 (cero) in that column.
thanks --- El mié 2-sep-09, Simon Davies <[email protected]> escribió: > De: Simon Davies <[email protected]> > Asunto: Re: [sqlite] Integer Storage class > Para: "General Discussion of SQLite Database" <[email protected]> > Fecha: miércoles, 2 de septiembre de 2009, 9:12 am > 2009/9/2 Sebastian Bermudez <[email protected]>: > > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > Yahoo! Cocina Encontra las mejores recetas con Yahoo! Cocina. http://ar.mujer.yahoo.com/cocina/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
