Create Tables with CLOB Columns

JDBC for MySQL - Herong's Tutorial Examples

∟MySQL CLOB (Character Large Object) - TEXT

∟Create Tables with CLOB Columns

This section describes how to create tables with CLOB (LONGTEXT) columns in MySQL server.

MySQL server support CLOB with 4 data types:

TINYTEXT - A CLOB column with a maximum length of 255 (2**8 - 1) characters.
TEXT - A CLOB column with a maximum length of 65,535 (2**16 - 1) characters.
MEDIUMTEXT - A CLOB column with a maximum length of 16,777,215 (2**24 - 1) characters.
LONGTEXT - A CLOB column with a maximum length of 4,294,967,295 or 4GB (2**32 - 1) characters.

In order to test CLOB columns in MySQL server, I used the MySQL command line interface to create a test table with one CLOB column:

herong> mysql -u Herong -pTopSecret

mysql> use HerongDB;
Database changed

mysql> CREATE TABLE Article (ID INTEGER PRIMARY KEY AUTO_INCREMENT,
    ->   Subject VARCHAR(256) NOT NULL,
    ->   Body LONGTEXT);
Query OK, 0 rows affected (0.38 sec)