If you exceed the maximum length, you get the following error:
*** JSON value is too large to store in the defined JSON type.
For example, if you try to insert data that is larger than the maximum length defined for a JSON column, or pass data that is larger than what is supported by a JSON parameter, you get this error.
For a JSON column that uses a binary format, you can load binary data that fits within the defined length of the column, but this data may exceed the maximum allowed size for the output (text) format. The data may be stored in binary format, but cannot be retrieved as text format. You get this error when trying to access this data as text. If you encounter this problem, you can do one of the following:
- Cast the data to a JSON type with a larger maximum length.
- Cast the data to a predefined type (VARCHAR/VARBYTE/CLOB/ BLOB).
- Select the data using the AsJSONText or AsBSON methods.