Is there a way to cause SQLite to load dynamic extensions via DbVis?

SQLite has the ability to load custom extensions at runtime. One great extension is the Unicode library [Nunicode|https://bitbucket.org/alekseyt/nunicode] which provides unicode collation and case folding features. There apears to be a SQLite function, [load_extension] https://www.sqlite.org/lang_corefunc.html#load_extension which could be used to load the extension but this is throwing an error in DbVis. The error is "[SQLITE_ERROR] SQL error or missing database (near "load_extension": syntax error)" If using SQLite from the command line, the extension can be loaded using the syntax ".load ". Any suggestions for doing this via DbVis would be greatly appreciated. Thanks Tom Edited by: Hans Bergsten on Oct 29, 2015 9:11 PM

Hi Tom, This is most likely a driver issue, as it seems like the driver does not recognize the syntax. I don't have this enabled and I do not have an extension readily available to test with, but when I add "select" to the function call, I get a different error message that seems to indicate that the statement is at least passed to the database: select load_extension('foo') If this doesn't work, please ask for help in the SQLite driver community: https://bitbucket.org/xerial/sqlite-jdbc Best Regards, Hans