'SQL logic error no such module: fts5'
(1) By zrzr23 on 2020-10-14 16:57:21 [link] [source]
I am using C#, System.Data.SQLite, version 1.0.113.0
when I use the following code to create virtual table for full text search,
CREATE VIRTUAL TABLE vCustomer USING fts5(....)
I got the error "'SQL logic error no such module: fts5'"
How do I enable it in C#?
Thanks!
(2) By Luca (jedioetzi) on 2022-05-26 14:46:34 in reply to 1 [source]
try the following:
... connection.Open();
connection.EnableExtensions(true); connection.LoadExtension("SQLite.Interop.dll", "sqlite3_fts5_init");