Home | History | Annotate | Line # | Download | only in man 
      1 .Dd April 29, 2026
      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
     21 Every value in SQLite has one of five fundamental datatypes:
     22 .Bl -bullet
     23 .It
     24 64-bit signed integer
     25 .It
     26 64-bit IEEE floating point number
     27 .It
     28 string
     29 .It
     30 BLOB
     31 .It
     32 NULL
     33 .El
     34 .Pp
     35 These constants are codes for each of those types.
     36 .Pp
     37 Note that the SQLITE_TEXT constant was also used in SQLite version
     38 2 for a completely different meaning.
     39 Software that links against both SQLite version 2 and SQLite version
     40 3 should use SQLITE3_TEXT, not SQLITE_TEXT.
     41 .Sh IMPLEMENTATION NOTES
     42 These declarations were extracted from the
     43 interface documentation at line 5334.
     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