SQL Server CLOB (Character Large Object)

JDBC for SQL Server - Herong's Tutorial Examples

∟SQL Server CLOB (Character Large Object) - TEXT

This chapter provides tutorial notes on CLOB (Character Large Object) data types, TEXT, with SQL Server JDBC Driver. Topics include creating tables to store CLOB values in SQL Server 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

Closing InputStream Too Early on setCharacterStream()

Retrieving CLOB Values with getString() Method

Retrieving CLOB Values with getCharacterStream() Method

Retrieving CLOB Values with getClob() Method

Inserting CLOB Values with setClob() Method

Takeaways:

MS SQL Server support CLOB data type with column type of VARCHAR(MAX).
Character data can be directly inserted into a CLOB column using the INSERT statement.
Character data can also be indirectly inserted into a CLOB column using the PreparedStatement object with setSring(), setCharacterStream(), and setClob() methods.
Character data can be retrieved from a CLOB column using getString(), getCharacterStream(), and getClob() methods on the ResultSet object.