Re^2: JSON::XS utf8 formatted string will not load into MYSQL json type column

in reply to Re: JSON::XS utf8 formatted string will not load into MYSQL json type column
in thread JSON::XS utf8 formatted string will not load into MYSQL json type column

This should be very little surprise. When you print out your SQL string, you will find that the ' in don't is read as terminating the quotes around '$_'. DBI placeholders circumvent the problem.

Comment on Re^2: JSON::XS utf8 formatted string will not load into MYSQL json type column Select or Download Code

Replies are listed 'Best First'.
Re^3: JSON::XS utf8 formatted string will not load into MYSQL json type column by misterperl (Friar) on Aug 25, 2023 at 19:14 UTC
Great idea I'm on it!	[reply]

In Section Seekers of Perl Wisdom