Joanne Pham wrote: > I have read online document regarding SQLITE3 data type and below is list of > these datatypes: > * TEXT > * NUMERIC > * INTEGER > * REAL > * NONE > But just now I found out SQLITE3 has bigint and int as another datatype. SQLite doesn't assign types to columns the way other databases do, but it does support int and bigint values. The INTEGER storage class stores signed integers using as many bytes (up to 8) as are needed.
> Can you direct me where I can find out the complete list of SQLITE datatypes > and the size of each datatype. > Googling for "sqlite datatypes" returns the Datatypes In SQLite Version 3 <http://www.sqlite.org/datatype3.html> page, which describes both SQLite's storage classes and its type affinities. That's the doc I always reference for details on datatypes in SQLite. -myk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
