JSON datatype length

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.