# CLOB and BLOB

Derby supports the standard CLOB and BLOB data types. BLOB and CLOB values are limited to a maximum of 2,147,483,647 characters.

Parent topic: Derby and standards
Related concepts
Dynamic SQL
Cursors
Information schema
Transactions
Stored routines and PSM
Calling functions and procedures
Unique constraints and nulls
NOT NULL characteristic
DECIMAL max precision
Expressions on LONGs
ALTER TABLE