<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<p>Gilles, Thanks for clarifying the situation. Cheers Simon<br>
</p>
<br>
<div class="moz-cite-prefix">On 10/07/18 06:11, Gilles Caulier
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAHFG6sE3A5UqxYcZQ_oWvifcGejmOKuaB6NvhHGHiQ3jBiWaxA@mail.gmail.com">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<div class="gmail_quote">2018-07-09 2:57 GMT+02:00 Simon
Cropper <span dir="ltr"><<a
href="mailto:scropper@botanicusaustralia.com.au"
target="_blank" moz-do-not-send="true">scropper@botanicusaustralia.com.au</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<p>In my mind this seems to imply that your directory,
file names and maybe even your associated metadata
have characters not shared between Linux and Windows.</p>
<p>Linux uses UTF-8 while Windows CP-1252. They are
different code pages and when characters unique to one
or other code page is used in a system that is not
code-page aware -- like Windows, the programs get
upset.<br>
</p>
The only way to resolve the issue is to fix the
offending paths, file names or metadata.<br>
<br>
This is applicable for any program and is not unique to
DigiKam.<br>
<br>
Although this may not be the main problem, my
understanding is that the path of files are stored as
UUID+Path. I am not sure how robust the conversion
routines are converting paths between Linux/UNIX format
and Windows Format. Some of the issues may relate to
this. Certainly most people report problems when moving
their data between drives as this changes the UUID.<br>
<br>
If I have the time, to test, I'd create one directory
with a small number of files. Check all of them for any
character that is are not a-z, A-Z, 0-9, space and _<br>
<br>
Duplicate on your NAS.<br>
<br>
Try creating a database in Linux using one of the
directories.<br>
Try creating a database in Windows using the other
directory.<br>
<br>
Try adding the Linux directory to Windows install and
visa versa. I suspect this won't work. If it does, then
the issue you are reporting is probably just code page
incompatibility and you need to seek out the offending
characters.<br>
<br>
<b>@Gilles -- This list regularly gets queries about how
to setup a central photo repositories and have
multiple clients looking into the a single database.
In most cases, like Clive its involves mixed operating
systems. I have never seen a clear response from the
developers if this is even feasible. Can you please
clarify?</b>
<div>
<div class="h5"><b><br>
</b></div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>Sharing the database between different Operating system
is problematic. Characters encoding is one, event if this
can be fixed to use UTF8 everywhere. Qt is able to
converter from one encoding to another one easily.</div>
<div><br>
</div>
<div>But the most important is enable database lock
mechanisms to prevent concurrent access at the same time
from different computers. It's can be complex and
introduce limitation certainly in this kind of use. We
have already few entries in bugzilla about this topic.</div>
<div><br>
</div>
<div>In others words, i don't recommend to play in this
configuration for the moment, or at least in only this
case :</div>
<div><br>
</div>
<div>- same type of OS access to a centralized the database
(Mysql)</div>
<div>- only one computer use the database, no more than one
at the same time.</div>
<div>- collection are shared on the network, and UUID to
identify the collection are the same everywhere (else data
will be duplicated in database).</div>
<div><br>
</div>
<div>Best</div>
<div><br>
</div>
<div>Gilles Caulier</div>
</div>
</div>
</div>
</blockquote>
<br>
<div class="moz-signature">-- <br>
Cheers Simon <br>
<br>
<span style="padding:3em"> Simon Cropper</span><br>
<span style="padding:3em"> Principal Consultant</span><br>
<span style="padding:3em"> Botanicus Australia Pty Ltd</span><br>
<span style="padding:3em"> M: 0420 531 754.</span><br>
<span style="padding:3em"> W:
<a class="moz-txt-link-freetext" href="http://www.simonchristophercropper.com">http://www.simonchristophercropper.com</a></span><br>
<br>
</div>
</body>
</html>