JDBC for MySQL - Herong's Tutorial Examples - v3.12, by Herong Yang
MySQL CLOB (Character Large Object) - TEXT
This chapter provides tutorial notes on CLOB (Character Large Object) data types, TEXT, with MySQL JDBC Driver. Topics include creating tables to store CLOB values in MySQL server; inserting CLOB values with direct SQL INSERT statements, or PreparedStatement with setString(), setCharacterStream() or setClob() methods; retrieving CLOB values from ResultSet with getString(), getCharacterStream() or getClob() method.
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
Takeaways:
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
MySQL BLOB (Binary Large Object) - BLOB