Fundamental Datatypes (original) (raw)
Small. Fast. Reliable.
Choose any three.
#define SQLITE_INTEGER 1 #define SQLITE_FLOAT 2 #define SQLITE_BLOB 4 #define SQLITE_NULL 5 #ifdef SQLITE_TEXT
undef SQLITE_TEXT
#else
define SQLITE_TEXT 3
#endif #define SQLITE3_TEXT 3
Every value in SQLite has one of five fundamental datatypes:
- 64-bit signed integer
- 64-bit IEEE floating point number
- string
- BLOB
- NULL
These constants are codes for each of those types.
Note that the SQLITE_TEXT constant was also used in SQLite version 2 for a completely different meaning. Software that links against both SQLite version 2 and SQLite version 3 should use SQLITE3_TEXT, not SQLITE_TEXT.