Sorry I was mistaken I actually use CGI::Application::Plugin::Session but I
will look into your suggestion.
Many thanks,
Simon
On Tue, 17 Aug 2021 at 10:14, <r...@savage.net.au> wrote:
> Hi Simon
>
> Did you see the same issue when replacing the deprecated CGI::Session
> with my module Data::Session?
>
> I must confess I don't expect the latter to fix this particular problem.
>
> ---
> Cheers
> Ron
> savage.net.au
>
>
> On 2021-08-17 17:41, Simon Cruickshank wrote:
> > I use perl CGI::Session on a Debian buster box, after upgrading to
> > Bullseye the website barfs with message :-
> >
> > DBD::mysql::db do failed: Incorrect string value:
> > '\xF9\x08a\x00\x00\x00...' for column `webapp`.`sessions`.`a_session`
> > at row 1 at /usr/share/perl5/CGI/Session
> >
> > I can recreate the issue without CGI:Session with the following code.
> >
> > #! /usr/bin/perl -w
> > use strict;
> > use DBI;
> >
> > my ($dbh, $sth, $count);
> >
> > $dbh = DBI->connect
> > ("DBI:mysql:host=localhost;database=webapp","webadmin","?????????",
> > {PrintError => 0, RaiseError => 1});
> > $sth = $dbh->prepare ("insert into sessions values (?,?)");
> > my ($id,$a_session) = ($ARGV[0],$ARGV[1]);
> > $a_session = "\x{F9}";
> > $sth->execute ($id,$a_session)
> > or die $DBI::errstr;
> > $sth->finish ();
> > $dbh->disconnect ();
> > exit (0);
> >
> > So the issue just seems to be with UTF8? This works fine on Buster but
> > not Bullseye. If I encode_utf8 the string the insert works.
> >
> > Is this a change in the mysql backend or a change in the DBI?
> >
> > Any help would be greatly appreciated.
> >
> > Best Regards,
> >
> > Simon
>
