https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19670 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ere.maijala@helsinki.fi, | |katrin.fischer@bsz-bw.de --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I confirm, it's still _ci: -- -- Table structure for table 'search_marc_map' -- DROP TABLE IF EXISTS search_marc_map; CREATE TABLE `search_marc_map` ( id int(11) NOT NULL AUTO_INCREMENT, index_name ENUM('biblios','authorities') NOT NULL COMMENT 'what storage index this map is for', marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for', marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field', PRIMARY KEY(`id`), UNIQUE key `index_name` (`index_name`, `marc_field` (191), `marc_type`), INDEX (`index_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; As we are also using uppercase letters to extent the item subfields, I'd be interested in fixing this. Note: we already have the different collation on marc_subfield_structure.tagsubfield for the same reason. Can we agree on this change? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.