Summary: | dk only shows one file if two files only differ in lower/upper case extension | ||
---|---|---|---|
Product: | [Applications] digikam | Reporter: | Kusi <kusi> |
Component: | Database-Mysql | Assignee: | Digikam Developers <digikam-bugs-null> |
Status: | RESOLVED FIXED | ||
Severity: | normal | CC: | caulier.gilles, metzpinguin |
Priority: | NOR | ||
Version: | 7.3.0 | ||
Target Milestone: | --- | ||
Platform: | openSUSE | ||
OS: | Linux | ||
Latest Commit: | https://invent.kde.org/graphics/digikam/commit/56c96d9aadca8a2108c08b09888541e52a0eedea | Version Fixed In: | 7.5.0 |
Description
Kusi
2021-11-22 23:04:06 UTC
*** This bug has been marked as a duplicate of bug 414344 *** Historically, MySQL is case insensitive. We would have to use utf8-bin as the context so that special characters still work as well. This binary storage of strings also has some disadvantages, for example the search would also be case sensitive, compared to the search in SQLite which is case insensitive. It would be possible to perform a context conversion for the search query, but this is much slower. Maik I see. However, the problem here is that digikam "swallows" the error without notifying the user. You can set a tag to an image, and when you restart digikam, the tags are gone. If you restart again, the tags are here again. The alternating images/hiding of images is not obvious to the user. A warning like: "Digikam cannot handle upper/lower case differences. Please rename the images outside of Digikam" would already be good enough Fixed with commit: https://invent.kde.org/graphics/digikam/-/commit/56c96d9aadca8a2108c08b09888541e52a0eedea Maik 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 435767, 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 |