[Koha-bugs] [Bug 28489] CGI::Session is incorrectly serialized to DB in production env / when strict_sql_modes = 0

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28489

--- Comment #31 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
It can be recreated easily using:

use Koha::Cities;
use CGI::Session::Serialize::default;
#$Data::Dumper::Useperl = 1;
use utf8;
my $branchname = "TESTÄ/Testä";
my $hash = { branch => $branchname };
my $s = CGI::Session::Serialize::default->freeze($hash);
$hash = CGI::Session::Serialize::default->thaw($s);
Koha::City->new({city_name => $hash->{branch}})->store;


It fails with 
  Incorrect string value: '\xC4/Test...' for column 'city_name' at row 1

But inserts the city correctly if the Useperl line is uncommented.

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