What is BLOB and TEXT in MySQL?

MySQLMySQLi Database. BLOB stands for Binary Large Objects and as its name suggests, it can be used for storing binary data while TEXT is used for storing large number of strings. BLOB can be used to store binary data that means we can store pictures, videos, sounds and programs also.

What datatype is BLOB?

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.

What is the difference between BLOB and TEXT?

BLOB is used for storing binary data while Text is used to store large string. BLOB values are treated as binary strings (byte strings). They have no character set, and sorting and comparison are based on the numeric values of the bytes in column values.

What is TEXT data type in MySQL?

TEXT is the family of column type intended as high-capacity character storage. The actual TEXT column type is of four types-TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT. The four TEXT types are very similar to each other; the only difference is the maximum amount of data each can store.

What is BLOB data in MySQL?

A Binary Large Object ( BLOB ) is a MySQL data type that can store binary data such as images, multimedia, and PDF files.

What is BLOB SQL?

An SQL BLOB is a built-in type that stores a Binary Large Object as a column value in a row of a database table. By default drivers implement Blob using an SQL locator(BLOB) , which means that a Blob object contains a logical pointer to the SQL BLOB data rather than the data itself.

How do I view BLOB files in MySQL?

Perform three steps:

  1. Go to “WorkBench Preferences” –> Choose “SQL Editor” Under “Query Results”: check “Treat BINARY/VARBINARY as nonbinary character string”
  2. Restart MySQL WorkBench.
  3. Now select SELECT SUBSTRING(,1,2500) FROM ;

What is BLOB used for?

BLOB stands for Binary Large Object. It is defined as the chunk of binary data being stored as a single entity in a database system. BLOBs are used primarily to hold multimedia objects like images, videos, and sound, though they can also be used to store programs.

What is BLOB data type in MySQL?

A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types are TINYBLOB , BLOB , MEDIUMBLOB , and LONGBLOB . These differ only in the maximum length of the values they can hold. The four TEXT types are TINYTEXT , TEXT , MEDIUMTEXT , and LONGTEXT .

What is the use of BLOB data type in MySQL?

How do I query BLOB data in MySQL?

How to Convert From BLOB to Text in MySQL?

  1. Step 1: Create a database. we can use the following command to create a database called geeks.
  2. Step 2: Use database.
  3. Step 3: Table definition.
  4. Step 5: View the content.
  5. Query:
  6. Step 2: Add content to column UPDATE demo_table SET AFTER_CONERSION = CONVERT (FILE using utf8);

Why BLOB is used in MySQL?

Introduction to MySQL BLOB. Blob is the data type in MySQL that helps us store the object in the binary format. It is most typically used to store the files, images, etc media files for security reasons or some other purpose in MySQL.

Which data type sometimes is called Blob?

A binary large object ( BLOB) is a collection of binary data stored as a single entity. Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob. They can exist as persistent values inside some databases, or exist at runtime as program variables in some languages.

How to get blob image from MySQL database?

Node.js upload/store image in MySQL overview.

  • Project Structure
  • Setup Node.js modules.
  • Configure MySQL database&Sequelize.
  • Initialize Sequelize.
  • Define the Sequelize Model.
  • Create middleware for uploading&storing image.
  • Create Controller for uploading Images.
  • Create Controller for the view
  • Create View for uploading image.
  • What is the difference between Blob and CLOB datatypes?


  • TEXT
  • How to get size of Blob in MySQL?

    – TINYBLOB – length+ 1 bytes, where length< 2^8 – BLOB – length+ 2 bytes, where length< 2^16 – MEDIUMBLOB – length+ 3 bytes, where length< 2^24 – LONGBLOB – length+ 4 bytes, where length< 2^32