SQLite Forum

JSON literals, how they work
Login
There is no JSON type. Giving a declared type of JSON results in numeric affinity. The literal 'true' does not look like a number so the result of the cast is 0.