This example creates a table MyTable with the JSON auto column j.
CREATE TABLE MyTable ( a INTEGER, b INTEGER, j JSON AUTO COLUMN);
This table definition for MyTable includes the JSON auto column j defined with a length of 64K bytes and Latin character set.
CREATE TABLE MyTable ( a INTEGER, b INTEGER, j JSON(64000) CHARACTER SET LATIN AUTO COLUMN);
This table definition for MyTable includes the JSON column c, which is not an auto column, and the JSON auto column j defined with a length of 64K bytes and Latin character set.
CREATE TABLE MyTable ( a INTEGER, b INTEGER, c JSON, j JSON(64000) CHARACTER SET LATIN AUTO COLUMN);