Sql - Binary large object (BLOB) data type

Data System Architecture

About

Binary large object (BLOB) is a SQL data type suited to store a blob file (ie binary data).

In a database, a blob is implemented via pointer to the local file system (known as a lob (large object)

SQL queries restrictions

It is generally not allowed to use them in a:




Discover More
Card Puncher Data Processing
Oracle - LOB Datatype

LOB in Oracle In Oracle, a LOB is simply a pointer that points to an index that is stored in a LOBINDEX segment. The index points to the chunks that make up the LOB that are stored in LOBSEGMENT segment....
Data System Architecture
SQL - Data Type (Column Type)

The Data Type of a column in SQL. They are defined in the ANSI/ISO SQL standard but may vary from sql engine (database) to another. The below table shows you the history of the data type in the ANSI...
Data System Architecture
SQL - LOB (large object)

The term large object (LOB) refers to a data item that is too large to be stored directly in a database table. Instead, a pointer is stored in the database table, which points to the location of the...
Undraw File Manager Re Ms29
What is a Blob (Binary Large Object) ?

blob stands for binary large object and represents the file content in binary data. Because in a computer, all data are binary data, this name is used logically to represent any file content where the...



Share this page:
Follow us:
Task Runner