From 6a7341c98d84a59807ae4a74c9c28343979a081b Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Mon, 22 Jan 2018 12:32:21 -0300 Subject: [PATCH] Bug 18336: SET NAMES utf8mb4 in Koha::Database Sponsored-by: Hotchkiss School Signed-off-by: Mark Tompsett Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi Signed-off-by: Kyle M Hall Signed-off-by: Jonathan Druart --- Koha/Database.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Koha/Database.pm b/Koha/Database.pm index 52962b2612..e97c794a45 100644 --- a/Koha/Database.pm +++ b/Koha/Database.pm @@ -73,7 +73,7 @@ sub _new_schema { my $tz = $ENV{TZ}; if ( $db_driver eq 'mysql' ) { %encoding_attr = ( mysql_enable_utf8 => 1 ); - $encoding_query = "set NAMES 'utf8'"; + $encoding_query = "set NAMES 'utf8mb4'"; $tz_query = qq(SET time_zone = "$tz") if $tz; $sql_mode_query = q{SET sql_mode = 'IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'}; } -- 2.20.1