Character encoding of filenames in the zotero.sqlite database

I want to extract a list of all file attachment paths from my Zotero Standalone library. It is quite easy to find this list of paths in the zotero.sqlite database, using SQLite Manager. However, special characters appear in these paths, e.g.

instead of

Still, within Zotero, such linked file names are shown as normal.

Any ideas on how to solve this? I use Zotero Standalone 4.0.28 with ZotFile 4.1.6 on Linux Mint Qiana.
Sign In or Register to comment.