Joanne Pham <[EMAIL PROTECTED]> 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.
Where and how did you "find this out"? SQLite has just one integer data type, storing 64-bit signed integers. In your CREATE TABLE statement, you can use BIGINT or INT or any other identifier that contains "INT" as a substring to indicate integer affinity. > Can you direct me where I can find out the complete list of SQLITE > datatypes and the size of each datatype. http://sqlite.org/datatype3.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
