On 9/20/16, Richard Hipp wrote: > Maybe don't double the double-quotes. JSON expects just a single > double-quote a either end of a string.
The tools I user (sqlite explorer) wanted it. And after I do update records set message=replace(message,'""','"'); So there is NO double quote in the database. Regards Gilles Vollant _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users