SQLite Forum

Windows x64 SQLite extensions...
Login
Once you open a connection execute the SQL command `pragma compile_options;` which will return to you a list of the options that were used to compile the SQLite3 library (just like a select statement).  You should see `ENABLE_FTS5` in the list if FTS5 was enabled in the library when the maker compiled it from the source code.  If it is not listed then the FTS5 code was not enabled and you will have to speak to whomever is responsible for your wrapper as to how/why it is not included/enabled.

My SQLite3 has the following results for pragma compile_options because I have enabled a boatload of features (some of which are non-standard/custom):

```
ALLOW_COVERING_INDEX_SCAN
ALLOW_URI_AUTHORITY
COMPILER=gcc-10.2.0
DEFAULT_CACHE_SIZE=-1048576
DEFAULT_FOREIGN_KEYS
DEFAULT_PAGE_SIZE=4096
DEFAULT_RECURSIVE_TRIGGERS
DEFAULT_WAL_AUTOCHECKPOINT=256
DEFAULT_WAL_SYNCHRONOUS=1
DEFAULT_WORKER_THREADS=8
ENABLE_8_3_NAMES=1
ENABLE_API_ARMOR
ENABLE_BYTECODE_VTAB
ENABLE_COLUMN_METADATA
ENABLE_COLUMN_USED_MASK
ENABLE_COSTMULT
ENABLE_CURSOR_HINTS
ENABLE_DBSTAT_VTAB
ENABLE_FTS3
ENABLE_FTS3_PARENTHESIS
ENABLE_FTS4
ENABLE_FTS5
ENABLE_JSON1
ENABLE_LOAD_EXTENSION
ENABLE_LOCKING_STYLE=1
ENABLE_MATH_FUNCTIONS
ENABLE_MEMORY_MANAGEMENT
ENABLE_PREUPDATE_HOOK
ENABLE_RBU
ENABLE_RTREE
ENABLE_SESSION
ENABLE_SNAPSHOT
ENABLE_STAT4
ENABLE_STMT_SCANSTATUS
ENABLE_UNKNOWN_SQL_FUNCTION
ENABLE_UPDATE_DELETE_LIMIT
EXPLAIN_ESTIMATED_ROWS
EXTRA_INIT=core_init
HAVE_ISNAN
LIKE_DOESNT_MATCH_BLOBS
MAX_ATTACHED=15
MAX_WORKER_THREADS=16
SOUNDEX
STAT4_SAMPLES=64
TEMP_STORE=1
THREADSAFE=1
USE_DATETIME_NEW
USE_PRECISE_TIME
USE_QUADMATH
USE_URI
```

The (DLL) build available from the website look something like this:

```
COMPILER=msvc-1500
ENABLE_BYTECODE_VTAB
ENABLE_COLUMN_METADATA
ENABLE_DBSTAT_VTAB
ENABLE_FTS3
ENABLE_FTS4
ENABLE_FTS5
ENABLE_GEOPOLY
ENABLE_JSON1
ENABLE_RTREE
ENABLE_STMTVTAB
MAX_TRIGGER_DEPTH=100
TEMP_STORE=1
THREADSAFE=1
```