summaryrefslogtreecommitdiff
path: root/external/public-domain/sqlite/man/SQLITE_INTEGER.3
blob: 3c8e65cc53683bd01dc3e93db3f4d044571fe347 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
.Dd December 19, 2018
.Dt SQLITE_INTEGER 3
.Os
.Sh NAME
.Nm SQLITE_INTEGER ,
.Nm SQLITE_FLOAT ,
.Nm SQLITE_BLOB ,
.Nm SQLITE_NULL ,
.Nm SQLITE_TEXT ,
.Nm SQLITE3_TEXT
.Nd Fundamental Datatypes
.Sh SYNOPSIS
.Fd #define SQLITE_INTEGER
.Fd #define SQLITE_FLOAT
.Fd #define SQLITE_BLOB
.Fd #define SQLITE_NULL
.Fd #define SQLITE_TEXT
.Fd #define SQLITE3_TEXT
.Sh DESCRIPTION
Every value in SQLite has one of five fundamental datatypes: 
.Bl -bullet
.It
64-bit signed integer 
.It
64-bit IEEE floating point number 
.It
string 
.It
BLOB 
.It
NULL 
.El
.Pp
These constants are codes for each of those types.
.Pp
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.