Bug 435767

Summary: Files with same name but different case are hidden
Product: [Applications] digikam Reporter: Paul Worrall <p.r.worrall>
Component: Database-MysqlAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: metzpinguin
Priority: NOR    
Version First Reported In: 7.2.0   
Target Milestone: ---   
Platform: Neon   
OS: Linux   
Latest Commit: https://invent.kde.org/graphics/digikam/commit/56c96d9aadca8a2108c08b09888541e52a0eedea Version Fixed/Implemented In: 7.5.0
Sentry Crash Report:

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