![]() The following SQL demonstrates some of the above:- DROP TABLE IF EXISTS example You may wish to refer to Datatypes in SQLite The column will also be restricted to being an integer value (the columns using the other listed types will not be restricted to integer values). If you included INTEGER in the list then YES it will make a difference as the column will then be an alias of the rowid column (i.e. ) as the types all contain INT they will have a type affinity of INTEGER and the column will NOT be an alias of the rowid column. as per Any column in an SQLite version 3 database, except an INTEGER PRIMARY KEY column, may be used to store a value of any storage class. ![]() The value stored MUST be an integer otherwise a DATATYPE MISMATCH will occur. The exception is the use specifically of INTEGER PRIMARY KEY or INTEGER with the column set as the primary key at the table level. ![]() Storage Classes and Datatypes in the link below SQL does not differentiate between stored values other than the storage class (null,integer,real,text,blob), if stored as an INTEGER then it is an integer bound only by the limitations of it being stored in at most 8 bytes (64 bit signed).
0 Comments
Leave a Reply. |