1.

What Is Blob And Text In Mysql?

Answer»

BLOB is an acronym stands for BINARY LARGE object. It is used to hold a variable amount of data.

There are four types of BLOB.

  1. TINYBLOB
  2. BLOB
  3. MEDIUMBLOB
  4. LONGBLOB

The DIFFERENCES among all these are the maximum length of values they can hold. TEXT is case-insensitive BLOB. TEXT values are non-binary strings (character string). They have a character set and values are stored and compared based on the collation of the character set.

There are four types of TEXT.

  1. TINYTEXT
  2. TEXT
  3. MEDIUMTEXT
  4. LONGTEXT

BLOB is an acronym stands for binary large object. It is used to hold a variable amount of data.

There are four types of BLOB.

The differences among all these are the maximum length of values they can hold. TEXT is case-insensitive BLOB. TEXT values are non-binary strings (character string). They have a character set and values are stored and compared based on the collation of the character set.

There are four types of TEXT.


Discussion

No Comment Found

Related InterviewSolutions