[Digikam-users] Re: How to make digikam show all images in a folder?

[Daniel Bauer]

On Sunday 06 March 2011 23:11:33, Marcel Wiesweg wrote:
> > This would give an ugly name clash on windows, were case is ignored.
> > Normally one should avoid such situations for portability reasons.
> > 
> > Still digikam could try to show both images and maintain them, there
> > would be no portable way accross operating systems, which is a
> > requirement.
> 
> As "jdd" already pointed out and I could confirm in a small test, digikam
> is without a problem capable to display xy.png and xy.PNG side by side. We
> dont use IgnoreCase comparisons anywhere to my knowledge.
> So I cannot reproduce here, there must be some special context triggering
> the problem.
> 
> Marcel

Marcel, do you use MySQL database?
It is a reproducible bug:
https://bugs.kde.org/show_bug.cgi?id=268204

I could solve it for me with a change in the database of which I hope it 
wouldn't have any negative side effects... 

The collation IS case-INsensitive. filenames of upper/lower-case are treatened 
the same, if the SELECT commands do not have a COLLATE statement. As mentioned 
in my bug report, I'd recommend to add a COLLATE statement to all SELECT 
commands in the database handling of digikam, OR to change teh collation of 
case-sensivitve fields.

My test showed that this only applies to MySQL database. When using sqlite the 
bug doesn't exist.

By the way: I was pointed to this by a hint on the OpenSuse-Mailing list by 
members that were so kind to test with my test-folders...

kind regards...

Daniel

-- 
Daniel Bauer photographer Basel Barcelona
professional photography: http://www.daniel-bauer.com
erotic nudes: http://www.guapamania.com