[Koha-bugs] [Bug 13810] Prevent updatedatabase.pl from breaking because of case insensitive utf8 collation

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13810

--- Comment #1 from Nicolas Legrand <nicolas.legrand at bulac.fr> ---
Created attachment 36744
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=36744&action=edit
Change default collation to utf8_bin

When upgrading database from 3.18 to master upgrade Upgrade to
3.19.00.006 (Bug 11944 - Convert DB tables to utf8_unicode_ci) may
fail like this:

DBD::mysql::db do failed: Duplicate entry 'ACQ-995-a' for key 'PRIMARY' at
./installer/data/mysql/updatedatabase.pl line 9671.

This is from table marc_subfield_structure where the keys are made of
framework (ACQ), tagfield (995) and tagsubfield (a). If we have a key
ACQ-995-A it thinks the entries are duplicates, because the collation
is case insensitive. It's rather annoying, since it's legit in mark to
have a subfield 'a' different from subfield 'A' inside the same
subfield.

utf8_bin prevent updatedatabase.pl from breaking.

-- 
You are receiving this mail because:
You are watching all bug changes.