Create Tables with CLOB Columns

JDBC Tutorials - 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)

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Installing and Running Java DB - Derby

Derby (Java DB) JDBC Driver

Derby (Java DB) JDBC DataSource Objects

Java DB (Derby) - DML Statements

Java DB (Derby) - ResultSet Objects of Queries

Java DB (Derby) - PreparedStatement

MySQL Installation on Windows

MySQL JDBC Driver (MySQL Connector/J)

MySQL - PreparedStatement

MySQL - Reference Implementation of JdbcRowSet

MySQL - JBDC CallableStatement

►MySQL CLOB (Character Large Object) - TEXT

Overview of CLOB (Character Large Object)

►Create Tables with CLOB Columns

Inserting CLOB Values with SQL INSERT Statements

Inserting CLOB Values with setString() Method

Inserting CLOB Values with setCharacterStream() Method

Retrieving CLOB Values with getString() Method

Retrieving CLOB Values with getCharacterStream() Method

Retrieving CLOB Values with getClob() Method

Inserting CLOB Values with setClob() Method

MySQL BLOB (Binary Large Object) - BLOB

Oracle Express Edition Installation on Windows

Oracle JDBC Drivers

Oracle - Reference Implementation of JdbcRowSet

Oracle - PreparedStatement

Oracle - JBDC CallableStatement

Oracle CLOB (Character Large Object) - TEXT

Oracle BLOB (Binary Large Object) - BLOB

Microsoft SQL Server Express Edition

Microsoft JDBC Driver for SQL Server

Microsoft JDBC Driver - Query Statements and Result Sets

Microsoft JDBC Driver - DatabaseMetaData Object

Microsoft JDBC Driver - DDL Statements

Microsoft JDBC Driver - DML Statements

SQL Server - PreparedStatement

SQL Server CLOB (Character Large Object) - TEXT

SQL Server BLOB (Binary Large Object) - BLOB

JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver

JDBC-ODBC Bridge Driver - Flat Text Files

JDBC-ODBC Bridge Driver - MS Access

JDBC-ODBC Bridge Driver - MS SQL Server

Summary of JDBC Drivers and Database Servers

Using Connection Pool with JDBC

Archived Tutorials

Full Version in PDF/EPUB