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