[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] json arrays
From:       Simon Slavin <slavins () bigfraud ! org>
Date:       2016-05-30 23:54:30
Message-ID: FCFBF269-055C-47E7-BDF7-78117D782735 () bigfraud ! org
[Download RAW message or body]


On 31 May 2016, at 12:49am, Scott Doctor <scott@scottdoctor.com> wrote:

> Should numbers in a json array have quotes around the numbers?

If you want an answer strictly about JSON, no quotes.  This is a number:

12.34

and this is a string:

"12.34"

.  I don't know whether SQLite implements this correctly but I'd assume it does until \
you have evidence to the contrary.  Given how SQLite works, if you've defined a \
column as numeric and feed it the string "12.34" you'll get a number anyway.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[prev in list] [next in list] [prev in thread] [next in thread]