This section describes what are BLOB (Binary Large Object) data types and how to work with them.
BLOB (Binary Large Object) is a large collection of binary data stored in a database table. Different database servers handles
BLOB differently. But there are some common characteristics like:
BLOB stores binary data, which requires no encoding schema. BLOB data is stored in units of bytes.
BLOB data is usually large. Many database servers offer very high maximum sizes like 4 GB.
BLOB data is usually not directly stored inside the table. It is stored in different storage areas
and its reference address is stored inside the table.
JDBC offers an interface, java.sql.Blob, to allow JDBC driver to provide generic functionalities
to handle BLOB data in the database.
BLOB data can also be handled as byte arrays: byte[].
BLOB data can also be handled as binary streams with the java.io.InputStream class.
The data type and definition was introduced to describe data not originally defined in traditional computer database systems