Bug 435767 - Files with same name but different case are hidden
Summary: Files with same name but different case are hidden
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Mysql (other bugs)
Version First Reported In: 7.2.0
Platform: Neon Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-04-15 12:03 UTC by Paul Worrall
Modified: 2021-12-20 14:51 UTC (History)
1 user (show)

See Also:
Latest Commit: https://invent.kde.org/graphics/digikam/commit/56c96d9aadca8a2108c08b09888541e52a0eedea
Version Fixed/Implemented In: 7.5.0
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Paul Worrall 2021-04-15 12:03:50 UTC 
Using digiKam on Linux with photos stored on an ext3 formatted disk, if two files have the same name, differing only in case (e.g.  photo.jpg  and photo.JPG) only one of them is displayed by digiKam.

SOFTWARE/OS VERSIONS
Operating System: KDE neon 5.21
KDE Plasma Version: 5.21.4
KDE Frameworks Version: 5.81.0
Qt Version: 5.15.2
Kernel Version: 5.4.0-71-generic
OS Type: 64-bit
Graphics Platform: X11
Processors: 2 × AMD A6-6400K APU with Radeon(tm) HD Graphics
Memory: 7.7 GiB of RAM
Graphics Processor: AMD CEDAR
Comment 1 Maik Qualmann 2021-04-15 16:18:01 UTC 

*** This bug has been marked as a duplicate of bug 414344 ***
Comment 2 Maik Qualmann 2021-04-15 16:20:47 UTC 
The problem is, if we make the file names case sensitive, the search is also case sensitive. At SQLite she is case insensitive to search.

Maik
Comment 3 Maik Qualmann 2021-04-15 16:25:28 UTC 
The cause is MySQL as database.

Maik
Comment 5 Maik Qualmann 2021-12-20 14:51:00 UTC 
Git commit 56c96d9aadca8a2108c08b09888541e52a0eedea by Maik Qualmann.
Committed on 20/12/2021 at 07:16.
Pushed by mqualmann into branch 'master'.

use COLLATE utf8_bin for album path and image name
Related: bug 414344, bug 445948, bug 447233
FIXED-IN: 7.5.0

M  +4    -4    NEWS
M  +11   -2    core/data/database/dbconfig.xml.cmake.in
M  +9    -1    core/libs/database/coredb/coredbschemaupdater.cpp

https://invent.kde.org/graphics/digikam/commit/56c96d9aadca8a2108c08b09888541e52a0eedea