SQLite Studio and RMNOCASE
I recently moved from using SQLite Expert Personal to SQLite Studio, mainly to take advantage of their custom function feature.
I thought all was good until I tried to look at FactTypeTable and hit the dreaded RMNOCASE issue. I've scoured their site and this one, but I can't find any specific instructions for how to deal with this issue.
Any guidance?
Two responses from my outdated experience with SQLite Studio:
- The first is from SQLite Managers for Mac OS (2017-02-26)in which I said that SQLiteStudio 3 auto substitutes the normal NOCASE collation when it encounters RMNOCASE
- The second is from my configuration of version 3.4.4 (the current one is 3.4.11 so I need to update) in which I apparently used the Extension Manager to add unifuzz64.dll (RMNOCASE - faking it in SQLite Expert, command-line shell et al ), with the option to "Register in all databases". @PatJones posted the procedure in the comments on that page.
If you are on MacOS or Linux, there is also discussion about adapting unifuzz.c for them.
It's very easy in SQLite Studio as you just add that unifuzz64.dll.
If you copy the unifuzz.dll file (use 64 bit version if using 64 bit SQLite Studio) to the installed SQLite Studio\ext folder (e.g. C:\Program Files\SQLiteStudio\ext ) , it adds the extension automatically and you simply have to, in SQLite Studio, select Tools, Extension Manager and select unifuzz (or unifuzz64), select “for all databases” and select the tick button to confirm changes.
Excellent, thank you very much!