JDBC for MySQL - Herong's Tutorial Examples - v3.12, by Herong Yang
Overview of CLOB (Character Large Object)
This section describes what are CLOB (Character Large Object) data types and how to work with them.
CLOB (Character Large Object) is a large collection of character data stored in a database table. Different database servers handles CLOB differently. But there are some common characteristics like:
JDBC offers an interface, java.sql.Clob, to allow JDBC driver to provide generic functionalities to handle CLOB data in the database.
CLOB data can also be handled as character strings with the java.lang.String class.
CLOB data can also be handled as character streams with the java.io.Reader class.
Table of Contents
JDBC (Java Database Connectivity) Introduction
MySQL JDBC Driver (MySQL Connector/J)
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