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

[Marcel Wiesweg]

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





--- Comment #8 from Marcel Wiesweg <marcel wiesweg gmx de>  2011-03-17 20:49:15 ---

> When the database has collation utf8_unicode_ci, as far as I know you can
> always use "WHERE BINARY" or "COLLATE utf8_bin" in the select statements where
> case sensitive behaviour is necessary....

That could be the easier solution... Images.name, Albums.relativePath,
AlbumRoots.specificPath, and in some cases also AlbumRoots.identifier are
critical. Need to check if there are more fields involved. At least until now,
no other obscure bugs have been discovered.

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