The maximum length of the JSON text depends on the character set being used as follows:
- For UNICODE, the maximum length is 8388096 characters.
- For LATIN, the maximum length is 16776192 characters.
8388096 UNICODE characters or 16776192 LATIN characters are equivalent to 16776192 bytes, which is the absolute maximum length for the JSON type.
If no maximum length is specified, the default maximum length for the character set is chosen. If specified, the length is subject to a minimum of two characters and cannot be greater than the absolute maximum for the character set. If the character set is not specified, the character set of the user is used.