SQLite Forum

Is there a json_unquote()?
Login

Is there a json_unquote()?

(1) By Paul van Helden (paulvh) on 2020-05-22 12:51:27 [source]

..to use a JSON string returned from the json functions?

(2) By Richard Hipp (drh) on 2020-05-22 13:06:20 in reply to 1 [link] [source]

The json_extract() function should return an unquoted string when the PATH argument refers to a string value.

(3) By Paul van Helden (paulvh) on 2020-05-22 13:29:18 in reply to 2 [link] [source]

OK, thanks, but I've made my own json_unquote now so that I can use it on a return value from another json function. I think this would be a sensible addition?