> > I wonder, though, if there may still remain a problem for other shells > (SQLite managers?) that do not support loadable extensions, e.g., free > versions of SQLite Expert, SQLite Developer, ...
You are mistaken. The free version of SQLite Expert supports loadable extensions. Bogdan Ureche author of SQLite Expert On Fri, Jun 21, 2013 at 4:28 PM, Tom Holden <[email protected]> wrote: > Richard Hipp drh at sqlite.org > Fri Jun 21 00:15:56 EDT 2013 wrote: > > Can you not compile your custom collation sequences into a loadable > extension (a DLL or shared library), then load that extension into your > SQLite shell? > http://www.sqlite.org/loadext.**html<http://www.sqlite.org/loadext.html> > > --------- > > Tom replies: > With Ralf's help, that's what I have done with SQLiteSpy in 2011 after it > started to support loadable extensions. While I see that SQLite3.exe > supports loadable extensions, I am not a programmer in C and barely a > novice in MS Visual Studio C#. The fake collation DLL for SQLiteSpy won't > load into SQLite3.exe; it was compiled in Delphi. > > Having a loadable extension for the custom collation sequence SQLite3.exe > would get around the problem with some modification in batch scripts to > cause it to load but would leave the SQL scripts as is. It would open up > other uses for the command line shell to modify the custom-collated data. > That would be good. If someone is willing to give me an extension for > SQLite3.exe that gives the name RMNOCASE to a NOCASE equivalent collation > sequence, that would be wonderful! > > I wonder, though, if there may still remain a problem for other shells > (SQLite managers?) that do not support loadable extensions, e.g., free > versions of SQLite Expert, SQLite Developer, ... > > Thanks for your responses, Richard. > > > Tom > ______________________________**_________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
