On 9/20/16, Gilles Vollant <vollan...@gmail.com> wrote: > > delete from records; > insert into records values (1,'2016-09-01',22,'{""Date"":""09/01/2016 > 02:00:00"",""CountAnalyzedMails"":44} ');
Maybe don't double the double-quotes. JSON expects just a single double-quote a either end of a string. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users