View Single Post
Old 08-26-2018, 01:39 PM   #38
retrography
Member
retrography is on a distinguished road
 
Posts: 23
Karma: 50
Join Date: Jul 2018
Location: Amsterdam
Device: Onyx Boox Max 2 / PocketBook Inkpad 3 / Kindle Paperwhite 3
Quote:
Originally Posted by ubuntero View Post
Thanks "retrography". There useful script.

I ve tried to add default Unicode encoding for html to the script, but without success.
Hey @ubuntero,

As far as I know the default database encoding in SQLite is UTF8, and the exported HTML must be UTF8 encoded by default (see my sample file attached to my last post). Maybe your books are not UTF8 encoded, but as far as I know PocketBook should be able to take care of that.

You can check your DB encoding using:

Code:
PRAGMA encoding;
If the database itself is not UTF8 or if by Unicode you mean UTF-16 or UTF-32, then I suggest exporting the HTML with the default encoding and then do the conversion outside.

But all in all, I am not a database or text encoding expert. I would personally never load anything non-Unicode on my reader first place so that I don't get into encoding issues afterwards. I have lost precious notes like that before.
retrography is offline   Reply With Quote