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

Reply via email to