A BLOB (binary large object) is a varying-length binary string that can be up to 2,147,483,647 characters long. Like other binary types, BLOB strings are not associated with a code page. In addition, BLOB strings do not hold character data.
The length is given in bytes for BLOB unless one of the suffixes K, M, or G is given, relating to the multiples of 1024, 1024*1024, 1024*1024*1024 respectively.
A BLOB without a specified length is defaulted to two gigabytes (2,147,483,647).
java.sql.Blob
BLOB
Use the getBlob method on the java.sql.ResultSet to retrieve a BLOB handle to the underlying data.
see