From 0f706aab0ccfddeeb56bcc95470effdd0caaae71 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 24 Nov 2016 13:55:13 +0000 Subject: [PATCH] Bug 17676: Update default COLLATE of marc_subfield_structure Patch for branches < 16.11 See bug 17676 for more information Signed-off-by: Mark Tompsett --- installer/data/mysql/updatedatabase.pl | 1 + 1 file changed, 1 insertion(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index e8ca11e..18789c5 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9732,6 +9732,7 @@ if ( CheckVersion($DBversion) ) { MODIFY COLUMN seealso varchar(1100) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY COLUMN link varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL |); + $dbh->do(qq|ALTER TABLE $name CHARACTER SET utf8 COLLATE utf8_unicode_ci|); } else { $dbh->do(qq|ALTER TABLE $name CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci|); -- 2.1.4