mysql2/promise escaping apostrophes on insert

[jasonmacer]

I am running into an issue where I am setting a variable to JSON.stringify() and then inserting that as the value into a JSON column in the database.

Here is the variable value before the insert statement (statement is trimmed):

{"56":"Describe any cramping or pain you may have<br><br><br><br>blank line then new line's here","57":"Yes","58":"pain at any other time<br><br>next line's<br><br><br><br>blank lines then next"}

And then, after the insert statement, it looks like this:

{"56":"Describe any cramping or pain you may have<br><br><br><br>blank line then new line\'s here","57":"Yes","58":"pain at any other time<br><br>next line\'s<br><br><br><br>blank lines then next"}

If you'll look at 56, 58 (and there are others) you'll notice that in the variable value before the insert the apostrophes are not escaped; however, on the insert they are.

What am I missing here?

I appreciate anyone's assistance.

TIA!

Jason

[sidorares]

hi @jasonmacer , could you create a small self contained example?

[croconut]

@jasonmacer i recommend refactoring to use JSON_OBJECT