BLOB (Binary Large Object) is a large object data type in the database system. BLOB could store a large chunk of data, document types and even media files like audio or video files. BLOB fields allocate space only whenever the content in the field is utilized. BLOB allocates spaces in Giga Bytes.

BLOB data type accepts image or audio file or video file or a document, to discriminate the type of the document stored in the field, certain databases has a property to the BLOB data fields to explain the document type stored in the BLOB data field.

To upload the document in to the BLOB field, database system provides data forms or a browser option to upload the files. This option enables the user to select and upload the document from the client system on which the data form is running. BLOB field doesn’t store the document immediately to the database; it stores the document in a temporary server initially, only when the user confirms the document upload the file is uploaded into the server.

The content in the BLOB field could be added, edited or updated. Data in the blob field do not comply with database SQL statements; we cannot search the data or manipulate the content in data field declared as BLOB using the SQL statements.

Product ID, Product Price, Product Description and Product Images are standard attributes of the products displayed in the website of any internet shopping sites. These details are stored in their product database. The image of the product shown in the shopping site, is a jpeg or gif file declared as a BLOB data type in the product database and the other fields product id, product description are the general data types like numeric, string.

Related posts:

1. Data Dictionary Data Dictionary is an organized file of details about the...
2. Flat File Flat file is static document, textual document that contains data...
3. What is Database Database is an integrated collection of logically related data or...
4. Document Management System To create a workable document management system solution for your...
5. Stored Procedure A Stored procedure is a subroutine written in the computer...