1.Dd January 24, 2024 2.Dt SQLITE_INTEGER 3 3.Os 4.Sh NAME 5.Nm SQLITE_INTEGER , 6.Nm SQLITE_FLOAT , 7.Nm SQLITE_BLOB , 8.Nm SQLITE_NULL , 9.Nm SQLITE_TEXT , 10.Nm SQLITE3_TEXT 11.Nd fundamental datatypes 12.Sh SYNOPSIS 13.In sqlite3.h 14.Fd #define SQLITE_INTEGER 15.Fd #define SQLITE_FLOAT 16.Fd #define SQLITE_BLOB 17.Fd #define SQLITE_NULL 18.Fd #define SQLITE_TEXT 19.Fd #define SQLITE3_TEXT 20.Sh DESCRIPTION 21Every value in SQLite has one of five fundamental datatypes: 22.Bl -bullet 23.It 2464-bit signed integer 25.It 2664-bit IEEE floating point number 27.It 28string 29.It 30BLOB 31.It 32NULL 33.El 34.Pp 35These constants are codes for each of those types. 36.Pp 37Note that the SQLITE_TEXT constant was also used in SQLite version 382 for a completely different meaning. 39Software that links against both SQLite version 2 and SQLite version 403 should use SQLITE3_TEXT, not SQLITE_TEXT. 41.Sh IMPLEMENTATION NOTES 42These declarations were extracted from the 43interface documentation at line 5009. 44.Bd -literal 45#define SQLITE_INTEGER 1 46#define SQLITE_FLOAT 2 47#define SQLITE_BLOB 4 48#define SQLITE_NULL 5 49#ifdef SQLITE_TEXT 50# undef SQLITE_TEXT 51#else 52# define SQLITE_TEXT 3 53#endif 54#define SQLITE3_TEXT 3 55.Ed 56