Hi All,
I want to store a column as a JSON datatype. I want to know what is the maximum column length available for a JSON datatype in SingleStore. If we define a column of JSON datatype is there any column length limit to it.
Hi Godiyal! Welcome to the SingleStore forums.
A JSON object can be no bigger than max_allowed_packet bytes, which by default is 104,857,600. You can set max_allowed_packet to up to 1,073,741,824 = 1024 * 1024 * 1024 = 2^30.
A little known secret is that our type system code nulls out values < max_allowed_packet in size. I’m going to open a ticket to get this documented.