SQLITE_INTEGER.3 revision 1.1.2.1 1 .Dd December 18, 2016
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 .Fd #define SQLITE_INTEGER
14 .Fd #define SQLITE_FLOAT
15 .Fd #define SQLITE_BLOB
16 .Fd #define SQLITE_NULL
17 .Fd #define SQLITE_TEXT
18 .Fd #define SQLITE3_TEXT
19 .Sh DESCRIPTION
20 Every value in SQLite has one of five fundamental datatypes:
21 .Bl -bullet
22 .It
23 64-bit signed integer
24 .It
25 64-bit IEEE floating point number
26 .It
27 string
28 .It
29 BLOB
30 .It
31 NULL
32 .El
33 .Pp
34 These constants are codes for each of those types.
35 .Pp
36 Note that the SQLITE_TEXT constant was also used in SQLite version
37 2 for a completely different meaning.
38 Software that links against both SQLite version 2 and SQLite version
39 3 should use SQLITE3_TEXT, not SQLITE_TEXT.
40