Updated: 2025/Nov/16

Please read Privacy Policy. It's for your privacy.

SQLITE_INTEGER(3)          Library Functions Manual          SQLITE_INTEGER(3)

NAME
     SQLITE_INTEGER, SQLITE_FLOAT, SQLITE_BLOB, SQLITE_NULL, SQLITE_TEXT,
     SQLITE3_TEXT - fundamental datatypes

SYNOPSIS
     #include <sqlite3.h>

     #define SQLITE_INTEGER
     #define SQLITE_FLOAT
     #define SQLITE_BLOB
     #define SQLITE_NULL
     #define SQLITE_TEXT
     #define SQLITE3_TEXT

DESCRIPTION
     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.

IMPLEMENTATION NOTES
     These declarations were extracted from the interface documentation at
     line 5009.

     #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

NetBSD 11.99                   January 24, 2024                   NetBSD 11.99