3.5. Data typename cross-compatibility Every SQL database engine seems to have its own unique set of supported datatype names: BIGINT UNSIGNED SMALL INT TEXT VARCHAR VARYING CHARACTER NATIONAL VARYING CHARACTER NVARCHAR JSON REAL FLOAT DOUBLE PRECISION ... and so forth ... The fact that SQLite will ... 

 ... The sort or comparison may give different results depending on which type of data is being sorted or compared. If data is of type text then the comparison is determined by the standard C data comparison functions memcmp() or strcmp ... 

SQLITE_SYNC_NORMAL, SQLITE_SYNC_FULL, SQLITE_SYNC_DATAONLY

 ... When the SQLITE_SYNC_DATAONLY flag is used, it means that the sync operation only needs to flush data to mass storage. Inode information need not be flushed. If the lower four bits of the flag equal SQLITE_SYNC_NORMAL, that means to use ... 

 ... Each table column will store any type of data, though columns have an affinity for the format of data defined by their declared datatype. When data is inserted into a column, that column will make an attempt to convert the ... 

2. STRICT Tables  ... Content inserted into the column with a datatype other than ANY must be either a NULL (assuming there is no NOT NULL constraint on the column) or the type specified. SQLite attempts to coerce the data into the appropriate type ... 

sqlite3_column_decltype(), sqlite3_column_decltype16()

 ... SQLite uses dynamic run-time typing. So just because a column is declared to contain a particular type does not mean that the data stored in that column is of the declared type. SQLite is strongly typed, but the typing ... 

 ... SQLite uses dynamic typing. It does not enforce data type constraints. Data of any type can (usually) be inserted into any column. You can put arbitrary length strings into integer columns, floating point numbers in boolean columns, or dates in ... 

 ... possible for SQLite to employ manifest typing instead of static typing. Readable source code The source code to SQLite is designed to be readable and accessible to the average programmer. All procedures and data structures and many automatic variables are ... 

3. Details  ... The 'struct iovec' type used for BLOB data is a standard Posix data structure, normally declared using "#include <sys/uio.h>". The format is: struct iovec { void *iov_base; /* Starting address */ size_t iov_len; /* Number of bytes to transfer */ };

sqlite3_update_hook()

 ... Whether the update hook is invoked before or after the corresponding change is currently unspecified and may differ depending on the type of change. Do not rely on the order of the hook call with regards to the final result ...