Bug 223050 - Unable to have directories with the same name case-insensitively
Summary: Unable to have directories with the same name case-insensitively
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Albums (show other bugs)
Version: 1.0.0
Platform: openSUSE Unspecified
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-01-17 00:04 UTC by Roman Prots'
Modified: 2017-07-25 17:15 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 1.1.0

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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