- 16776192 LATIN characters or 8388096 UNICODE characters for JSON text data
- 16776192 bytes for binary data
If the JSON type is being inserted into a column or used as an argument to a function or method, a check is performed to make sure that the actual length of the JSON data is less than or equal to the maximum length specified for this instance, because the actual length can be less than the absolute maximum. In any case where the data is too large for its current usage, an error is reported. Truncation does not occur.
In the default constructor, no arguments are passed to the constructor expression. NEW JSON() initializes an empty JSON type value with the character set based on the character set of the user. The data is set to a null string, and the default storage format is text.
If you pass an empty JSON object as an argument to the constructor, for example, NEW JSON(''), the constructor returns an empty JSON object.
You can use the NEW JSON constructor to construct a JSON document that is stored in a binary format. However, if sent to a client, the result of this constructor is sent as a CLOB that contains the text representation of the binary data.
You can append a JSON dot notation reference to the end of a constructor expression as described in JSON Dot Notation (Entity Reference).