https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21846 --- Comment #4 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Created attachment 82623 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=82623&action=edit Bug 21846: Make 'term' use utf8mb_bin collation on tags tables This patch makes the utf8mb4_bin collation preferred for comparing tags. Otherwise suppolemental unicode characters all match. To test: - Enable tags and disable moderation (or plan to moderate and accept tags) - Tag 3 records: a - with 🐋 b - with 🌮 c - with 👍 - Note the weight on each says '3' - Click the tag to search, you get back all the records - Apply the previous patches from this bug report - Run: $ kshell k$ prove t/db_dependent/Tags.t => FAIL: Tests fail, related to counting stuffs - Apply this patch and (a) Run updatedatabase to upgrade the schema - Run: k$ prove t/db_dependent/Tags.t => SUCCESS: Tests pass! (b) reset_all to get a fresh DB using kohastructure.sql - Run: k$ prove t/db_dependent/Tags.t => SUCCESS: Tests pass too! - Sign off :-D -- You are receiving this mail because: You are watching all bug changes.