[jackie_w]

Originally Posted by LucyOne

I'd like to use a custom en-en dictionary without having to reinstall it after every syncing process.
I've installed SQLiteSpy, but I have no idea how and what to enter into the Dictionary table. Could you give me some more detailed instructions, please?

1. Your custom en-en dictionary should be named dicthtml-en-en.zip and placed in the .kobo\dict directory
2. Prepare the SQL command you are going to run. It will be something like
   

   INSERT INTO "Dictionary" VALUES('-en-en','English - English OED_ed3','true',13379315,'','true');

   Replace the red bit with your choice of short helpful description (or nothing if you prefer)
   Replace the blue bit with the exact size in bytes of your dicthtml-en-en.zip file.
3. See attached screenshot. To insert the entry for the new dictionary into the Dictionary table
   • Copy your prepared SQL insert command into the top box (higher yellow highlight
   • Run the query (see red circle) via Execute > Execute SQL or [F9]
   • Once run, double-click the Dictionary table (lower yellow highlight) to see its contents. Your new entry should be visible (blue asterisk)
   • Exit SQLiteSpy.
4. Do a full power off/on cycle to get the new dictionary fully recognised by the Kobo.