Answer the question
In order to leave comments, you need to log in
How to fix incorrect json string?
In a table cell there is a line with data in the form of a json string. Ex:
"\u0410\u0431\u043e\u043d\u0435\u043d\u0442"
But it was not preserved correctly. Ex:
u0410u0431u043eu043du0435u043du0442
Forgot to put JSON_UNESCAPED_UNICODE before saving the string
.
Answer the question
In order to leave comments, you need to log in
Please clarify, should all "u" be replaced with "\u" or something more complicated?
Upd .:
I’ll take it out of the comment so that it’s clear if anyone else needs it:
If one line cannot have both, then the lines with which everything is in order are eliminated through where, and the replacement can be done through set field = replace(field, 'u', '\\u'). I'm not sure about the double slash, check it out.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question