From 60e8bd3377e9ff341af2cfc3c8f974e643beae8e Mon Sep 17 00:00:00 2001
From: Tomas Cohen Arazi <tomascohen@theke.io>
Date: Mon, 29 Jan 2018 10:02:21 -0300
Subject: [PATCH] Bug 18336: Fix missing utf8_bin > utf8mb4_bin translation in
 kohastructure.sql

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
---
 installer/data/mysql/kohastructure.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 87f6bc6d50..3ec79414fe 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -1131,7 +1131,7 @@ CREATE TABLE `creator_templates` (
 DROP TABLE IF EXISTS `marc_subfield_structure`;
 CREATE TABLE `marc_subfield_structure` (
   `tagfield` varchar(3) NOT NULL default '',
-  `tagsubfield` varchar(1) NOT NULL default '' COLLATE utf8_bin,
+  `tagsubfield` varchar(1) NOT NULL default '' COLLATE utf8mb4_bin,
   `liblibrarian` varchar(255) NOT NULL default '',
   `libopac` varchar(255) NOT NULL default '',
   `repeatable` tinyint(4) NOT NULL default 0,
-- 
2.16.1