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

Are you using DBI placeholders?

If not, you will have to think about how to quote your SQL string, as the backslash is interpreted by MySQL as a quoting character.

Comment on Re: JSON::XS utf8 formatted string will not load into MYSQL json type column

Replies are listed 'Best First'.
Re^2: JSON::XS utf8 formatted string will not load into MYSQL json type column by misterperl (Friar) on Aug 25, 2023 at 19:22 UTC
I removed all of my substitutes, changed to DBI placeholders , and presto ALL the issues are gone ! TY you were a great help I voted you a big ++ :)	[reply]
Re^2: JSON::XS utf8 formatted string will not load into MYSQL json type column by misterperl (Friar) on Aug 25, 2023 at 19:13 UTC
placeholders as in the "?" syntax? I have used those before; that's a very good suggestion Ill try that.. TY	[reply]