[Digikam-devel] [Bug 268204] New: MySQL filenames are case-INsensitive

[Daniel Bauer]

https://bugs.kde.org/show_bug.cgi?id=268204

           Summary: MySQL filenames are case-INsensitive
           Product: digikam
           Version: 1.8.0
          Platform: openSUSE RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database
        AssignedTo: digikam-devel at kde.org
        ReportedBy: linux at daniel-bauer.com


Version:           1.8.0 (using KDE 4.6.0) 
OS:                Linux

When using MySQL database, digikam cannot distinguish between filenames in
upper or lower case, i.e. of tho images "image.jpg" and "image.JPG" only one is
saved in the database.

This only occurs if using MySQL. 

Using sqlite this bug doesn't apply.

Reproducible: Didn't try

Steps to Reproduce:
While digikam not running, create a folder in the digikam album tree, put some
files giving them same names, but change some characters from lower to upper
case ("image.jpg", "image.JPG" etc.). Open digikam, search for new pictures,
and see.

When refreshing the album (F5) sometimes version "lower case", sometimes
version "upper case" is shown and the database gets updated accordingly. But it
contains always only one version...

Actual Results:  
Always on one file is shown and saved in the database ("image.jpg" OR
"image.JPG"). Upper/lower case is ignored.

Expected Results:  
As we are not on MS-DOS I want digikam to distinguish upper/lower-case as any
other program on linux or Mac does that...

The database "images" is collated case-insensitive (utf8-unicode-ci). I guess,
digikam searches the database to see if an image already exists, and the search
is done case-insensitive (without a COLLATE option).
I could solve the problem for me changing the collation of the field "name" in
"images" to latin1_general_cs. 
So ether the collations of the tables or fields should be changed to a
case-insensitive collation, or a COLLATE must be added to the appropriate
SELECT commands.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.