https://bugs.kde.org/show_bug.cgi?id=467766
--- Comment #33 from Petr Schonmann <pschonm...@gmail.com> --- Probably found that tables have bad collation, db not *** mysql> SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = 'digikam' LIMIT 1; +------------------------+ | DEFAULT_COLLATION_NAME | +------------------------+ | utf8mb4_unicode_ci | +------------------------+ 1 row in set (0.00 sec) *** but the tables have utf8mb3_general_ci. Ill do alter them and lets see. *** root@db:~# for i in $(mysql -NB -D digikam -e 'show tables;');do echo -ne "$i:" && mysql -D digikam -e "show table status like \"$i\"\G" | grep Collation ;done | column -t AlbumRoots: Collation: utf8mb3_general_ci Albums: Collation: utf8mb3_general_ci CustomIdentifiers: Collation: utf8mb3_general_ci DownloadHistory: Collation: utf8mb3_general_ci FaceMatrices: Collation: utf8mb3_general_ci FaceSettings: Collation: utf8mb3_general_ci FilePaths: Collation: utf8mb3_general_ci Identities: Collation: utf8mb3_general_ci IdentityAttributes: Collation: utf8mb3_general_ci ImageComments: Collation: utf8mb3_general_ci ImageCopyright: Collation: utf8mb3_general_ci ImageHaarMatrix: Collation: utf8mb3_general_ci ImageHistory: Collation: utf8mb3_general_ci ImageInformation: Collation: utf8mb3_general_ci ImageMetadata: Collation: utf8mb3_general_ci ImagePositions: Collation: utf8mb3_general_ci ImageProperties: Collation: utf8mb3_general_ci ImageRelations: Collation: utf8mb3_general_ci ImageSimilarity: Collation: utf8mb3_general_ci ImageTagProperties: Collation: utf8mb3_general_ci ImageTags: Collation: utf8mb3_general_ci Images: Collation: utf8mb3_general_ci KDTree: Collation: utf8mb3_general_ci Searches: Collation: utf8mb3_general_ci Settings: Collation: utf8mb3_general_ci SimilaritySettings: Collation: utf8mb3_general_ci TagProperties: Collation: utf8mb3_general_ci Tags: Collation: utf8mb3_general_ci TagsTree: Collation: utf8mb3_general_ci ThumbSettings: Collation: utf8mb3_general_ci Thumbnails: Collation: utf8mb3_general_ci UniqueHashes: Collation: utf8mb3_general_ci VideoMetadata: Collation: utf8mb3_general_ci *** -- You are receiving this mail because: You are watching all bug changes.
