[GNC] GnuCash SQLite: file attachments not recognized across platforms.

[tarik semrade]

Hello,

I am a GnuCash user and I use GnuCash on two machines: Linux and Windows.

I switched to the SQLite file format in order to use a Python library 
and be able to test and parse the SQLite database.

One issue I am facing concerns the use of *absolute paths on Windows*. 
When I started using GnuCash on Windows, I attached files using absolute 
paths. After some time, I realized that Windows paths could cause 
problems: when I open my book on another machine, the linked files are 
not recognized.

For this year, after resetting all the accounts, I want to start a new 
year with a more flexible method, since I use GnuCash from both Linux 
and Windows.

I used to use GitHub to synchronize the files. The GnuCash version on 
Windows is 5.5, while on my Ubuntu 25 system I use version 5.15. The 
book opens correctly without issues on both systems. However, one thing 
I tested was updating the Windows version of GnuCash to the latest 
release to match my Linux machine. I noticed that when I open the book 
with the latest Windows version, some strange characters appear. I 
reinstalled the 5.5 version since it works good.

If you have any recommendations to help resolve the issue with linked 
file paths, I would be very grateful.

Tarik