jooq mysql_JOOQ MySQL TEXT DataType

Use the corresponding SQLDataType instead.

You can use .column("ColumnName", SQLDataType.CLOB) for MySQL TEXT datatype.

The four TEXT (CLOB) types are TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. These differ only in the maximum length of the values they can hold.

If you use SQLDataType.CLOB(LENGTH) with vendor specific length, you will result in TINYTEXT, MEDIUMTEXT, LONGTEXT

Note that MySQL refers CLOB as TEXT

Usage examples

SQLDataType.INTEGER.identity(true) // INTEGER Primary key

SQLDataType.VARCHAR(4095).nullable(false) // VARCHAR(4095) NOT NULL

SQLDataType.CHAR(10) // CHAR(10)

SQLDataType.BLOB // BLOB

SQLDataType.CLOB) // TEXT, same as blob, but with character encoding associated

SQLDataType.CLOB(16777215) // MEDIUMTEXT

SQLDataType.CLOB(4294967295) // LONGTEXT