Bug 223050

Summary: Unable to have directories with the same name case-insensitively
Product: [Applications] digikam Reporter: Roman Prots' <rprots>
Component: Database-AlbumsAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: caulier.gilles, swatilodha27
Priority: NOR    
Version: 1.0.0   
Target Milestone: ---   
Platform: openSUSE   
OS: Unspecified   
Latest Commit: Version Fixed In: 1.1.0
Sentry Crash Report:

Description Roman Prots' 2010-01-17 00:04:10 UTC 
Version:            (using KDE 4.3.3)
Installed from:    openSUSE RPMs

Having the following directory layout:

109eos5d (having some raw images)
--preview (having some jpeg images)
109EOS5d (having some raw images)
--preview (having some jpeg images)

When "Include Album Sub-tree" is turned on I see images from 109EOS5d/preview directory when viewing contents of 109eos5d directory.
Comment 1 Marcel Wiesweg 2010-01-21 22:18:55 UTC 
SVN commit 1078245 by mwiesweg:

The SQL string operator "LIKE" is, at least for SQLite, case insensitive.
For albums, which are case sensitive on Unix, add an additional check in C++.

BUG: 223050

 M  +2 -1      NEWS  
 M  +11 -3     libs/database/albumdb.cpp  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1078245
Comment 2 swatilodha27 2016-06-02 13:28:12 UTC 
(In reply to Marcel Wiesweg from comment #1)

In coredb.cpp:3563 , reference for this bug is present. Since this one is already fixed, I would like to ask a general query if  using this "COLLATE Latin1_General_BIN" before LIKE operator could have been useful? (since LIKE is in-sensitive by default)

Regards